Date table - relationship

[dhannaa]

Hi all, 

I have been trying to learn basics and now I am stuck with date table. Can someone tell me, what seems to be the problem? 🙂 

This is what I want

This is what I get with date table.  YTD values don't seem to work.

[v-qiuyu-msft]

Hi @dhannaa,

How did you create the relationship between those two tables? Based on Date columns? If it is, please check if the Data Type for the Data column is set as Date type.

If issue persists, please share .pbix file with dummy data for us to analyze.

Best Regards,
Qiuyun Yu

[dhannaa]

Thanks for help!  The problem is that I cannot recreate the error, my new file with similar settings works like charm. It seems that previous file didn't see my dates as a date field although the data type was set on "date".

I'll get back to this if I get same error again!

[v-qiuyu-msft · Accepted solution]

Hi @dhannaa,

Which kind of Power BI desktop version did you run? Please try to run the latest version 2.48.4792.721 64-bit (July 2017). If the issue still persists, please share pbix file with us.

Best Regards,

Qiuyun Yu

[dhannaa]

This might be the answer - maybe I created the first file using an old version of Power BI. And now that it is updated I don't get the same error anymore. Great ! 🙂 

[v-qiuyu-msft]

Hi @dhannaa,

It seems we find where the issue is and the solution. Personally think we can close this thread now. If you agree with me, would you please mark a helpful reply as an answer?

Best Regards,
Qiuyun Yu

[dhannaa]

Yes of course, I’ll do that ! 

[v-qiuyu-msft]

Hi @dhannaa,

Thank you.

Best Regards,
Qiuyun Yu

[chethan]

switch the values correctly 

[dhannaa]

I kind of figured out the solution myself - i added the column "date" again to the date table. 

And now there is no problem anymore.   I still can't figure out, what is the problem with the first column.. any ideas?