PBI doesn't show some existing data from a excel source

[timazarj]

in my model tables have a relationship with the date table. when I count accounts per month, it doesn't show all months

and I am sure that there is data for March, April, & May. All Leads column is from the lead table and Count of Account is from Account table.

[Icey]

Hi @timazarj ,

Could you share me some screenshots about relationships among your tables?

Best Regards,

Icey

[timg · Accepted solution]

Hi timazarj,

Could you check whether the join between the date table and account table is correct? The date columns which are used in the join should be stored in the same format to make the join work properly.

Regards,

Tim