Mark as a data table

[miriambb]

Hallo everyone

I am trying to mark a table as a data table, but I am getting these errors 

Could you help me?

Thank you

Miriam

[tackytechtom · Accepted solution]

Hi @miriambb ,

It seems like you are trying to mark a fact table with multiple occurences of the same date as a date table. Instead you should create a separate date dimension with one date per row (without gaps) which then should have a relationship to your received_at column. 

Here some links on how to create such a date dimension:

Create date tables in Power BI Desktop - Power BI | Microsoft Docs

How to create a date table in Power BI in 2 simple steps - Kohera

Let me know if this helps 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

[miriambb]

Hi @Anonymous,

thank you for your help!

I did create the table however, the relationship between my table and the new one with only the date is not working...  I am assuming the common fields across both tables is the dates ? also i am assuming there is no need to the table as a date table?

Thank you

Miriam

[miriambb]

it worked 😄 thank you for your help!

Miriram