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
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..