Troubleshoot datetable

[Emmy88_]

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

[amitchandak]

@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-bd52912a5b...