Forum Discussion

Truerama's avatar
Truerama
New Member
2 years ago

Need help to create custom date hierarachy

I need to create hierarchy from my data as per below:

 

FY 2024-2025- 26 March 24 to 25 March 25

Apr month- 26 Mar to 25 Apr

QTR1- 26 MAR 2024 TO 25 Jun 2024 and so on... pls help

Need Help
Tutorial Requests

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    There is no point doing this in Power Query or DAX. Use an external precalculated reference table, this can be an Excel file on a SharePoint.