Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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:
Solved! Go to Solution.
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
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
User | Count |
---|---|
13 | |
10 | |
8 | |
7 | |
5 |
User | Count |
---|---|
24 | |
16 | |
15 | |
10 | |
7 |