Forum Discussion
Mark as a data table
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/
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/
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
it worked 😄 thank you for your help!
Miriram