Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

DAX - Substract

Dear all,   I'm trying to create a DAX formula to subtract the MAX from the MIN but without taking into consideration the value O in the column Kilometerstand. I can't filter the values without 0 a...
Need Help
  • johnt75's avatar
    johnt75
    4 years ago

    Try

    My Measure =
IF (
    2022 = 0,
    1,
    MAX ( '2022'[Kilometerstand] )
        - CALCULATE ( MIN ( '2022'[Kilometerstand] ), '2022'[Kilometerstand] > 0 )
)
Anonymous's avatar
Anonymous
Not applicable
4 years ago

johnt75thanks a lot. It's working like I imagined.