Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hey!
Can anyone see what gets wrong with my DAX formula?
I write following:
This is what TimeLoaded_LC is, and this is what NewRunLadoad gets:
I want it to take the current value, - previous value. as 988 - 987.9 = 0.1 and this value to be in NewRunLoad.
Thanks!
Kind regards
Agnes
Solved! Go to Solution.
Hi @Anonymous,
Please refer to below DAX formula:
NewRunLoad = IF ( CALCULATE ( MAX ( Data[Index] ), FILTER ( ALLEXCEPT ( Data, Data[Device] ), [Index] < EARLIER ( Data[Index] ) ) ) = BLANK (), BLANK (), Data[TimeLoaded_LC] - CALCULATE ( SUM ( Data[TimeLoaded_LC] ), FILTER ( ALLEXCEPT ( Data, Data[Device] ), [Index] = EARLIER ( Data[Index] ) - 1 ) ) )
Best regards,
Yuliana Gu
Hi @Anonymous,
Please refer to below DAX formula:
NewRunLoad = IF ( CALCULATE ( MAX ( Data[Index] ), FILTER ( ALLEXCEPT ( Data, Data[Device] ), [Index] < EARLIER ( Data[Index] ) ) ) = BLANK (), BLANK (), Data[TimeLoaded_LC] - CALCULATE ( SUM ( Data[TimeLoaded_LC] ), FILTER ( ALLEXCEPT ( Data, Data[Device] ), [Index] = EARLIER ( Data[Index] ) - 1 ) ) )
Best regards,
Yuliana Gu
Is this a measure?
Seems like your > sign in your minIndx VAR should be a < sign.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |