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")

     

PattemManohar's avatar
PattemManohar
Icon for Community Champion rankCommunity Champion
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")

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Amazing thanks!