Forum Discussion
Help with separate filter calendar
First time posting so apologies if this has already been covered.
I am trying to create a visual that will allow me to show expenses for budget, actuals forecast for each month of the fiscal calendar year selected. I have a matrix visual bringing back what I need however I need the graph to show every month.
I have found this DAX on youtube that brings back the last 6 months, however I want to amend this so it shows from April (first month of my fiscal year ) no matter what month is selected.
Any help would be appreciated - code I have is below:
I have managed to solve my own problem - simply replaced the "-6" with the variable "ReferenceDate" which makes the 1st month in the visual always show as April (being the 1st month of the fiscal year
1 Reply
- ShaneNewPBiNew Member
I have managed to solve my own problem - simply replaced the "-6" with the variable "ReferenceDate" which makes the 1st month in the visual always show as April (being the 1st month of the fiscal year