Forum Discussion
Solved
Calculated Column based on measure
Hi, I recently created a measure that creates a baseline for athletes' Day 1 testing results for a specific metric. We repeat this test on a daily basis, and I am attempting to see each day's % d...
Hi rgadbois ,
Please try following DAX:
RSI_BASELINE = CALCULATE(AVERAGE('CMJ'[RSI]),FILTER('CMJ','CMJ'[Date] = EARLIER('CMJ'[Date]))) Percentage = DIVIDE([RSI] - [RSI_BASELINE], [RSI_BASELINE])The result you want:
Best regards,
Yadong Fang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-yadongf-msft
Community Support
Community SupportHi rgadbois ,
Please try following DAX:
RSI_BASELINE = CALCULATE(AVERAGE('CMJ'[RSI]),FILTER('CMJ','CMJ'[Date] = EARLIER('CMJ'[Date])))
Percentage = DIVIDE([RSI] - [RSI_BASELINE], [RSI_BASELINE])
The result you want:
Best regards,
Yadong Fang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.