Forum Discussion

dhannaa's avatar
dhannaa
Helper IV
9 years ago
Solved

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? :)      This is what I want         This is what I...
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    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

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

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's avatar
dhannaa
Helper IV
9 years ago

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's avatar
    v-qiuyu-msft
    Community Support
    9 years ago

    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's avatar
      dhannaa
      Helper IV
      9 years ago

      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's avatar
        v-qiuyu-msft
        Community Support
        9 years ago

        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