Thank You for posting your query onto the Forum.
Below is the solution provided for the reference alongwith the screenshot about how you can sort the “Fiscal Month Name” in ascending order which will be in sync with the “Fiscal Week”.
So rather than sorting the “Fiscal Month Name” by “Fiscal Week”. Just select the field “Field Month Name” from the date field and sort it by “FIscal Month Number”.
- Result before Sorting -
- Select “Fiscal Month Name” into the Date table -
- Sort it by “Fiscal Month Number” -
Final Results -
I’m also attaching the working of the PBIX file for the reference.
Hoping you find this useful and meets your requirements that you’ve been looking for.
Thanks and Warm Regards,
Fiscal Year - Harsh.pbix (172.0 KB)