Forum Discussion

Sviatoslav's avatar
Sviatoslav
Regular Visitor
3 years ago
Solved

Subtract between two value using date slicer

Using slicer as in example i want to receive (13.10.200) 200 - (1.10.2022) 100 = 100

How can i resolve it with dax functions?

  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Sviatoslav 

    Add a slicer with Between type .

    Then create a measure to return the value of max date and min date to count the diff .

     

    Measure = 
    var _MAXdate=MAX('Table'[Date])
    var _MINdate=MIN('Table'[Date])
    return CALCULATE(SELECTEDVALUE('Table'[Value]),FILTER(ALL('Table'),'Table'[Date]=_MAXdate))-CALCULATE(SELECTEDVALUE('Table'[Value]),FILTER(ALL('Table'),'Table'[Date]=_MINdate))

     

    The final result is like below .

    Best Regards,
    Community Support Team _ Ailsa Tao
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Sviatoslav 

    Add a slicer with Between type .

    Then create a measure to return the value of max date and min date to count the diff .

     

    Measure = 
    var _MAXdate=MAX('Table'[Date])
    var _MINdate=MIN('Table'[Date])
    return CALCULATE(SELECTEDVALUE('Table'[Value]),FILTER(ALL('Table'),'Table'[Date]=_MAXdate))-CALCULATE(SELECTEDVALUE('Table'[Value]),FILTER(ALL('Table'),'Table'[Date]=_MINdate))

     

    The final result is like below .

    Best Regards,
    Community Support Team _ Ailsa Tao
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.