Forum Discussion
Date Column
Is it possible to give the relationship between the Date Table and another Table (which has no columns related to date).
If yes, please explain.
Thank you in advance.
Hi sivasrao ,
Is there any column related to date in another table, such as month, year, etc ?
If you have a such solumn, you can create relationship between between the month/year column and the data column.
If there is no such column, here's a reference for you.
This is my date table:
This is my another table, called sales table:
If there is an unique column, you can create relationship between date column and ID column.
For more information, please refer to:
Create and manage relationships in Power BI Desktop - Power BI | Microsoft Learn
Model relationships in Power BI Desktop - Power BI | Microsoft Learn
Best regards,
Yadong Fang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Hi sivasrao ,
Is there any column related to date in another table, such as month, year, etc ?
If you have a such solumn, you can create relationship between between the month/year column and the data column.
If there is no such column, here's a reference for you.
This is my date table:
This is my another table, called sales table:
If there is an unique column, you can create relationship between date column and ID column.
For more information, please refer to:
Create and manage relationships in Power BI Desktop - Power BI | Microsoft Learn
Model relationships in Power BI Desktop - Power BI | Microsoft Learn
Best regards,
Yadong Fang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
