Forum Discussion
Non-Contiguous Dates in Fact Tables
Hi, Can I still use Time Intelligence DAX functions in a situation like this? Will I need to create a contiguous dates in Date table and then connect it to both of my fact tables? My dates in the fac...
HI shaykoooo,
Yes, I think you may need a continuous calendar table to link each tables, then you can use time intelligence functions to use related calculator table to calculate with current table.
In addition, you can also try to use date function to manually setup data range filters, it not need a continuous calendar table.
Time Intelligence "The Hard Way" (TITHW)
Regards,
Xiaoxin Sheng
2020 and still using DATE() vs time intelligence functions, works for me for date columns tied to each table vs a date table.