Forum Discussion
blytonpereira
7 years agoHelper II
Linking calendar table issues
Hi Everyone, I have a dataset for example Period Brand Value 2018M01 XX 2 2018M01 XY 3 2018M01 XZ 2 2018M02 XZ 4 I now linked the "Period" colu...
- 7 years ago
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.
- 7 years ago
You have to activate the preview feature in the options
mwegener
7 years agoMost Valuable Professional
You have to activate the preview feature in the options
blytonpereira
7 years agoHelper II
mwegenerThankyou worked perfectly