Forum Discussion
Date Table
Hi, koorosh
'Mark as a date table' most of the time is to use the time intelligence functions. In fact, it is not suitable for newcomers if you need the date hierarchy. As you can see, you can’t use a default hierarchical structure to display data in visual.
If you want to create your own date table and define your own date hierarchy, you can mark as a date table.
Set and use date tables in Power BI Desktop - Power BI | Microsoft Docs
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.Best Regards,
Community Support Team _ Janey
koorosh it is best practice to common date dimension tables, few reasons:
- it reduces the size of the model rather than having hidden date tables for each date column in your model
- a common dimension to filter data in multiple fact tables.
- all above, ability to use DAX Time intelligence function for more common time-based analysis Time intelligence functions (DAX) - DAX | Microsoft Docs
✨ Follow us on LinkedIn
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Frankly, I have not been answered, where is Mark as Date Table useful while we got different result? Check the attached file please when he applies Mark as Date Table? Could we get YTD column without Mark as Date Table?
Regards
https://drive.google.com/file/d/10jDGmSawwh1H8yo-R2pje5Fh4XFtgnoK/view?usp=sharing