Forum Discussion
Linking calendar table issues
you use a financial calendar.
The Power BI time intelligence works with the "normal" calendar.
So the function SAMEPERIODLASTYEAR will not compare the same financial period.
"A disadvantage of the 4–4–5 calendar is that it has only 364 days (7 days x 52 weeks), meaning a 53rd week will need to be added every five or six years: this can make year-on-year comparison difficult."
Here my sample pbix file.
You have to activate the preview feature in the options
I'm not sure what you mean, but with drag an drop on the field list you could create your own hierarchy.
In the screenshot you uploaded it is wokring fine. However I tried downloading your file, the date Hierarchy is not create by default.
My goal is to create a simple hierarchy from the date = year quarter month day, just like in your screenshot.
And when I try to create this hierarchy as you described desribed above it does not seem to work
You have to activate the preview feature in the options
mwegenerThankyou worked perfectly
You have to activate the Preview feature in the Options