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...
Time Intelligence will work as long as your Date dimension table has contiguous dates set up and you mark it as a date table.
Now if your fact tables represents Snapshot at month end you need to be careful not to sum the data at the year Total but thatrs another topic
- So basically I can? And I am not sure I followed the second part of your answer, what is the caveat?
Time intelligence will work as normal. What I was saying is that if your month end data is a snapshot, for instance Quantity Available as of 31 October, Quantity Available as of 30 November etc then you need to be careful at the year level totals not to sum the quantities of all the months but just use the Quantity as of end of December for instance
