Date Column

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.