Forum Discussion

bob57's avatar
bob57
Icon for Helper IV rankHelper IV
4 years ago
Solved

Calculated Column

Hello, I'm hoping that someone can provide me with the DAX to accomplish the following Thank you for your time, Bob Here is the raw data: I need to add the calculated column, Difference: ...
Assistance
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi bob57 
    Here is a sample file with the solution https://we.tl/t-KWLD6ZeAMf

    Difference = 
VAR CurrentBase = Data[Base]
VAR CurrentRating = Data[Rating]
VAR CurrentMatchYesRating = CALCULATE ( MAX ( Data[Rating] ), ALLEXCEPT ( Data, Data[Match] ), Data[Base] = "yes" )
VAR Result =
    IF (
        CurrentBase = "no",
        CurrentRating - CurrentMatchYesRating,
        0
    )
RETURN
    ROUNDDOWN ( Result, 0 )

    You may need to readjust the rounding type as per your requirement. 

bob57's avatar
bob57
Icon for Helper IV rankHelper IV
4 years ago

My apologies. I neglected to mention that the calculation must be rounded to the nearest whole number.