pepito_el_co
New Member
- Joined
- Jan 14, 2022
- Messages
- 1
- Office Version
- 2019
- Platform
- Windows
Hi fellows. I have two not related tables cause of many to many relationships.
In first table, I have route details with many operations by each route like _ASS , PACK , PICK for exemple.
In second one, production orders as Production (unique values) and RouteID as many of them.
I'm trying to get for each Production (PDxxxxx), the Processtime by OPRID like _ASS with this mesure but I don't know how to consider PDxxxx in my filter
Route_time_ASS:=
var t= FILTER(Routes_details,Routes_details[OPRID]="***")
return
sumx(t,[PROCESSTIME])
Thanks for your help in advance
In first table, I have route details with many operations by each route like _ASS , PACK , PICK for exemple.
In second one, production orders as Production (unique values) and RouteID as many of them.
I'm trying to get for each Production (PDxxxxx), the Processtime by OPRID like _ASS with this mesure but I don't know how to consider PDxxxx in my filter
Route_time_ASS:=
var t= FILTER(Routes_details,Routes_details[OPRID]="***")
return
sumx(t,[PROCESSTIME])
Thanks for your help in advance