The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 |
---|---|
28 | |
12 | |
8 | |
7 | |
5 |
User | Count |
---|---|
34 | |
15 | |
12 | |
7 | |
6 |