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
mwegenerThanks for your reply.
I am not quite understanding your method as I am fairly new to POwerBI
I have shared the .pbix calendar file here
PLease try and edit the file itself if possible so I can understand more better
Thanks
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.
Thanks a lot. This worked perfectly. I followed your steps, creating a full financial calendar...and then creating a separate unique dates calendar for firest of each month....and then appending the unique dates to my original dataset.
Then I create a relationship Many (my dataset) to One (my full financial calendar). Works great.
I have one more problem:
For exmaple the date field in your full calendar table in PowerBI, is not a hierarchy, can we create a hierarchy from this ?
Any why is it not happening automatically ?
Thank you
Blyton
