Forum Discussion

rgadbois's avatar
rgadbois
Frequent Visitor
3 years ago
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...
Need Help
  • v-yadongf-msft's avatar
    v-yadongf-msft
    3 years ago

    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.

     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

rgadbois So like this?

_RSI_BASELINE =
  VAR __Athlete = [NAME]
RETURN
  MAXX(FILTER(CMJ, [NAME] = __Athlete && [Date]=DATE(2022,9,21)),[RSI])
  • rgadbois's avatar
    rgadbois
    Frequent Visitor
    3 years ago

    That does not work as there are numerous names within the [Name] column. There are 72 total athletes, each with one row added to the table on a daily basis.