Forum Discussion
Anonymous
6 years agoNot applicable
Missing date hierarchy
Hi all, i read through some threats but none seems to do the trick for me. I have following situation.... The setup seems similar. I added a calender table and linked accounting date ...
- 6 years ago
Hi Anonymous
Have you marked your date table as a date table?
https://docs.microsoft.com/en-us/power-bi/desktop-date-tables
The Idea of using date table is that you use the columns in the date table rater then hierarchies, try the below.
https://radacad.com/create-a-date-dimension-in-power-bi-in-4-steps-step-1-calendar-columns
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
LinkedIn
Mariusz
6 years agoCommunity Champion
Hi Anonymous
Have you marked your date table as a date table?
https://docs.microsoft.com/en-us/power-bi/desktop-date-tables
The Idea of using date table is that you use the columns in the date table rater then hierarchies, try the below.
https://radacad.com/create-a-date-dimension-in-power-bi-in-4-steps-step-1-calendar-columns
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
LinkedIn
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.