Forum Discussion

gerget's avatar
gerget
Frequent Visitor
8 years ago
Solved

Dates Table Relationship

Dear all,    I am having problems with creating a working relationship with the dates table I created in Power BI and unfortunately could not find a solution in the forum that worked for me. I hav...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    gerget,


    Could you please share sample data of your invoices table here? 

    As other's post, does the createdon column contain datetime values and you manually change the data type of the column to date? If so, the above issue will occur. You can create a calculated columns using dax below. Then create relationship between the new column and date column of dates table.

    newCreatedon=DATE( YEAR(invoices[createdon]) , MONTH(  invoices[createdon] ), DAY( invoices[createdon]))




    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

gerget,


Could you please share sample data of your invoices table here? 

As other's post, does the createdon column contain datetime values and you manually change the data type of the column to date? If so, the above issue will occur. You can create a calculated columns using dax below. Then create relationship between the new column and date column of dates table.

newCreatedon=DATE( YEAR(invoices[createdon]) , MONTH(  invoices[createdon] ), DAY( invoices[createdon]))




Regards,
Lydia

  • gerget's avatar
    gerget
    Frequent Visitor
    7 years ago

    Dear Lydia,

     

    this actually worked! Thank you so much for your help.

     

    Best, 
    gerget

  • Nirvay_KC's avatar
    Nirvay_KC
    New Member
    6 years ago

    Thank you Anonymous ! This was very helpful. In PowerBi Desktop (April 2020) , you could also use Date.From.