Reading Text Date Types as Dates For Fiscal Offset Table

[MDeFelice]

Hello - 

My organization has a dates table in their data warehouse that gives the Fiscal Year, Month, Quarter and Date for a calendar date because we run off a fiscal offset where our Year begins End of September OR the start of October ( What day in September OR October changes each year).

We have the date parts calculated but they are read in PowerBI as text because they are not looked at as date parts.  When I change them to dates they error out.  What I would like to do is get these to read as dates so I can have a hierarchy that flows correctly (for example Month goes in alpha not month order)

The Calendar Date is in the green box and the fiscaly fields I want to read as dates are in red.

Thanks

Mike

[V-lianl-msft · Accepted solution]

Hi @MDeFelice ,

Have you tried to create a new hierarchy?

After the hierarchy is created, if you have sorting issues, you can sort by date column.

If you still have issues, please paste some pictures to let us know more about your scenario.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@MDeFelice , Not very clear to me , see if this calendar can help

https://www.dropbox.com/s/klxcd8d3g21gran/Oct_2_Sep_Qtr_Cal.pbix?dl=0