Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Need help with some measures

Hello,   I need your help with a measure and have added some sample data below.  I want to calculate throughput time for each pallet, each pallet has 4 stages (palletstatuscodelog(1)) they are:  ...
Need Help
  • PattemManohar's avatar
    PattemManohar
    7 years ago

    Anonymous I guess you are looking for...

     

    Test29Out1 = CALCULATE(MAX(Test29[PalletStatusTijdstipLog]),Test29[PalletStatusCodeLog]= "Magazijn")

Test29Out2 = CALCULATE(MAX(Test29[PalletStatusTijdstipLog]),Test29[PalletStatusCodeLog]= "Palletvraag")

Test29Out3 = CALCULATE(MAX(Test29[PalletStatusTijdstipLog]),Test29[PalletStatusCodeLog]= "Opgezet")

Test29Out4 = CALCULATE(MAX(Test29[PalletStatusTijdstipLog]),Test29[PalletStatusCodeLog]= "Afgemeld")

     

AkhilAshok's avatar
AkhilAshok
Solution Sage
7 years ago

Something like this might help:

Throughput Time (Min) = 
DATEDIFF (
    MIN ( Table1[(1) OogstDatum] ),
    MIN ( Table1[PalletStatusTijdstipLog (1)] ),
    MINUTE
)

TimeMagazijn = 
CALCULATE (
    SUMX ( VALUES ( Table1[PalletID] ), [Throughput Time (Min)] ),
    Table1[PalletStatusCodeLog] = "Magazijn"
)

You can continue like this for other measures...