Incorrect Date reading

[Omega]

Hi,

I have two sheets in excel both have column called "Month" and both have the same exact format. When I drag one of them, power bi shows the dates for all the months and years while the other shows me only first date of each month. 

Please help. 

Thanks!

[v-jiascu-msft]

Hi @Omega,

Can you share your pbix file?

1. Where did you see the difference? If they are in different context, they will return different values.

2. What's the relationship?

3. Do they have the same values?

Best Regards,

Dale

[FlaF · Accepted solution]

I think you have to change the format of your column in data mode, where you have all your database: select your column and change the format in "modeling menu"