Forum Discussion
Time intelligence connected to date table with non date coumn
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.
Super UserAnonymous 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/38490
parry2k,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.⚡
- amitchandak
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.