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.
Hello:
The dataset I am working on relates to a company with June year end. Sales are available on a quarterly basis (Q1, Q2, Q3, Q4).
Fiscal Year End June XX | ||
2022 | Q1 | Jun-Sep 2021 |
2022 | Q2 | Oct-Dec 2021 |
2022 | Q3 | Jan-Mar 2022 |
2022 | Q4 | Apr-Jun 2022 |
I would like to provide an option in a slicer to toggle between fiscal year and calendar year annual comparisions (for eg. for calendar year 2022, the sum would include Q3 FY2022, Q4 FY2022, Q1 FY2023, Q2FY2023).
Any guidance on how to accomplish this would be much appreciated. Thanks in advance.
Solved! Go to Solution.
@isam2003 Too complicated to explain fully see attached PBIX file below signature. Involves 2 disconnected tables, a calculated column and a measure.
@isam2003 Too complicated to explain fully see attached PBIX file below signature. Involves 2 disconnected tables, a calculated column and a measure.
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 |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |