Forum Discussion

Yunka's avatar
Yunka
Advocate I
10 years ago
Solved

Last YTD DAX calculation by Fiscal Year

I have a dax calculation for running fiscal year total for the last YTD. Our fiscal year begins 6/1. This calculation works if I have a month slicer however if I don't want a month slicer, I want the...
Need Help
  • lalthan's avatar
    lalthan
    10 years ago

    If your calendar has the full period for current fiscal year and you don't have a time slicer, then it will always calculate and compare with whatever dates are available in your current financial year . You can add one more filter which filters the last date that you want the comparison to be done. e.g. lastnonblank(Period[Date],[whatever measure that you are tracking]).

     

    Otherwise, you can restrict your calender table to populate data till whatever date you want the comparison to be done

lalthan's avatar
lalthan
Resolver II
10 years ago

If your calendar has the full period for current fiscal year and you don't have a time slicer, then it will always calculate and compare with whatever dates are available in your current financial year . You can add one more filter which filters the last date that you want the comparison to be done. e.g. lastnonblank(Period[Date],[whatever measure that you are tracking]).

 

Otherwise, you can restrict your calender table to populate data till whatever date you want the comparison to be done