Date Column

[sivasrao]

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.

[v-yadongf-msft · Accepted solution]

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.

[Habitat]

Hi @sivasrao ,

What do you want to achieve by giving the relationship between the Date Table and another Table? 

Regards

Morty

[sivasrao]

Hi @Habitat 

I need to create quarter and monthly reports with the Second Table fields. For that, I have to link these two tables ( Date Table and Second Table)

Note: There are no Calendar and Date-related columns in the second table. 

I hope you understand my requirement.