Forum Discussion

Callmeadel's avatar
Callmeadel
New Member
4 years ago
Solved

RunningTotal to stop at max Date

Good afternoon,   I was just wondering what can of dax formula can I use to show the max date of my line the orange line is Actual transaction amount and blue line is the Estimated amount problem ...
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    Hi, Callmeadel 

     

    You can try the following methods.

    Measure:

    RunningTotal =
IF (
    MONTH ( SELECTEDVALUE ( 'Table'[Date] ) ) <= MONTH ( TODAY () ),
    CALCULATE (
        SUM ( 'Table'[Actual transaction] ),
        FILTER ( ALL ( 'Table' ), [Date] <= SELECTEDVALUE ( 'Table'[Date] ) )
    ),
    BLANK ()
)

    Is this the result you expect?

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more.

daXtreme's avatar
daXtreme
Icon for Solution Sage rankSolution Sage
4 years ago

Here it is how to do what you want.

 

Navigate to this page:

Standard time-related calculations – DAX Patterns

and then to this header:

Controlling the visualization in future dates

 

This shows exactly how to deal with such issues.

  • Callmeadel's avatar
    Callmeadel
    New Member
    4 years ago

    Thank you for the reply, I have created that measure it did say we can't use it on the report so how can it be used to fitler the graph? Do I drag it to filters because it won't let me add it to values.

    • Callmeadel's avatar
      Callmeadel
      New Member
      4 years ago

      They wanted me to use it in a column and then use a slicer that makes sense, but my table doesnt have any data after may so everything is returning True which still keeps the line 😞