Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Everybody:
I was doing this Sales report for the company i work for, and I was advice with doing the same report but to consider Fiscal Years instead of Regular Year. The first one starts on March and ends on February.
So my questions is how can I build the same report but having the results considering a year starting in March and ending up in February?
Kind regards.
Solved! Go to Solution.
@Anonymous,
If I'm understanding correctly, just add additional columns to your 'Calendar' table where you redefine the [MonthNum]. Then you'll have a normal calendar hierarchy and a fiscal hierarchy to place in your visual.
There are many ways to accomplish this either via DAX SWITCH ( ) or in Power Query Editior.
A pretty good article on SWITCH ( ) is found at https://powerpivotpro.com/2012/06/dax-making-the-case-for-switch/. The Power Query Editor column could be an IF ( ) or you can use this article https://www.powerquery.training/portfolio/replicate-power-pivots-switch-function/.
Proud to be a Super User!
@Anonymous,
If I'm understanding correctly, just add additional columns to your 'Calendar' table where you redefine the [MonthNum]. Then you'll have a normal calendar hierarchy and a fiscal hierarchy to place in your visual.
There are many ways to accomplish this either via DAX SWITCH ( ) or in Power Query Editior.
A pretty good article on SWITCH ( ) is found at https://powerpivotpro.com/2012/06/dax-making-the-case-for-switch/. The Power Query Editor column could be an IF ( ) or you can use this article https://www.powerquery.training/portfolio/replicate-power-pivots-switch-function/.
Proud to be a Super User!
Awesome Function!
That was what I've been looking for.
Gracias compadre @ChrisMendoza
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
93 | |
83 | |
70 | |
65 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |