Forum Discussion
Emmy88_
Advocate I
Advocate ITroubleshoot datetable
Hi all, I am building a report in power bi however somehow my monthly trend does not want to show when adding values. What am i missing here? 2 fact tables, action items & action plans 3 di...
amitchandak
Super User
Super UserEmmy88_ , Make sure you are using year and month from the common date table.
Also, make a date table that has all dates.
Also, make sure the date in the table does not have a timestamp, else join will
I have discussed more reasons and solutions
Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5bd4