Forum Discussion
Time intelligence connected to date table with non date coumn
Hi,
I have several date tables in my datamodel and to connect the facts table with a date tabel I use dateIDs.
It seems that I cannot use time intelligence in this case.
Is this correct? Do I need to use date column to connect to be able to use time intelligence?
Anonymous , there are only a few calculations where is important to mark it as date table. I have checked you can mark multiple tables as date tables.
5 Replies
- amitchandak
Super User
Anonymous , as long as you have continuous dates time intelligence will work.
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/
See if my webinar on Time Intelligence can help: https://community.powerbi.com/t5/Webinars-and-Video-Gallery/PowerBI-Time-Intelligence-Calendar-WTD-YTD-LYTD-Week-Over-Week/m-p/1051626#M184
Appreciate your Kudos. - parry2k
Anonymous The first thing which I would like to mention is why you have multiple date dimensions in your model. It is not a good practice until there is a reason for this.
Since you have date dimension, what time intelligence function is not working? What you actually tried and not worked? Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490parry2k,amitchandak tnx for tips!
Time intelligence is working now when I mark one date table as date table.
I have used time intelligence before in other reports and there I did not have to mark the date table as date table, in these cases I one have one date table. So if there are more than 1 date table in the datamodel then marking one data table as date table is neccessary to use time intelligence???- parry2k
Anonymous read this, and it is not clear why you have more than one date table. end of the day you will use one date table for time intelligence calculations so that everything interacts as you slice/dice the data.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos 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.⚡
