cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dhannaa Member
Member

Date table - relationship

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? Smiley Happy 

 

 

This is what I want

 

 

 

Sieppaa.PNG

 

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

 

Sieppaa2.PNG

 

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-qiuyu-msft
Moderator

Re: Date table - relationship

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
9 REPLIES 9
dhannaa Member
Member

Re: Date table - relationship

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

 

date.PNG

 

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

chethan Member
Member

Re: Date table - relationship

switch the values correctly 

Moderator v-qiuyu-msft
Moderator

Re: Date table - relationship

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.

 

q1.PNG

 

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

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
dhannaa Member
Member

Re: Date table - relationship

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!

Moderator v-qiuyu-msft
Moderator

Re: Date table - relationship

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
dhannaa Member
Member

Re: Date table - relationship

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 ! Smiley Happy 

Moderator v-qiuyu-msft
Moderator

Re: Date table - relationship

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
dhannaa Member
Member

Re: Date table - relationship

Yes of course, I’ll do that ! Smiley Happy

Moderator v-qiuyu-msft
Moderator

Re: Date table - relationship

Hi @dhannaa,

 

Thank you. Smiley Very Happy

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 248 members 2,633 guests
Please welcome our newest community members: