Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
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
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |