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

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.