Forum Discussion
Troubleshoot 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 dimensions, id, responsible & date table
- dates are mapped to the due dates of the fact tables
When trying to create a table with monthly figures year and month intel is not showing:
Which step am i missing?
gr,
emmy
1 Reply
Emmy88_ , 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
