Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
What is the best way to calculate QTD for fiscal year ending August 31. The default QTD only works with quarters ending in March, June, Sept and December
The following link will help you.
https://www.daxpatterns.com/custom-time-related-calculations/#
It creates a custom date calendar using a DAX formula.
You specify on the top the first fiscal month + you can customise all time dimensions
User | Count |
---|---|
56 | |
22 | |
19 | |
16 | |
11 |
User | Count |
---|---|
85 | |
54 | |
39 | |
21 | |
18 |