Forum Discussion

khaycock's avatar
khaycock
Icon for Helper I rankHelper I
6 years ago

Applying Year filter to Running Total

I'm struggling to get my running total to only include data from this fiscal year. I have data from previous years that I don't want to include in this running total but the following DAX only filter...
Need Help
khaycock's avatar
khaycock
Icon for Helper I rankHelper I
6 years ago

This works perfectly thank you! Is there anyway to keep the months in the future blank for CYTD rather than show the same figure?

 

jthomson's avatar
jthomson
Icon for Solution Sage rankSolution Sage
6 years ago

You could try taking the formula you have now and use conditional logic to compare the date in your date table to today, something like:

 

NewMeasure = if('Date'[Date] > today(),blank(),[YTD Sales])

  • khaycock's avatar
    khaycock
    Icon for Helper I rankHelper I
    6 years ago

    The IF statement on this measure doesn't let me use the Calendar Date field, it only lets me pick an existing Measure..