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 )
)
johnt75's avatar
johnt75
Icon for Super User rankSuper User
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

    johnt75Is there a possibility to that the calculation follows a date filter ?

     

    Example: I would like to filter on different months and then get the calculation performed just on this values. Would I need to adjust the Dax formula

    • johnt75's avatar
      johnt75
      Icon for Super User rankSuper User
      4 years ago

      As long as there is an active relationship from the date table to the 2022 table then it should just work, I don't think any changes are needed.