Relationships

Question

Dear All,&nbsp;&nbsp;Is it possible to create a table that holds all dates to and build the relationship to calendar using only that one date, like interval match in qlikview.&nbsp;&nbsp; Example&nbsp;&nbsp; Table 1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Interval Match &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Calendar&nbsp; &nbsp;&nbsp; Order Date &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Date &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Date&nbsp; &nbsp;&nbsp; Delivery Date &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Year&nbsp;Table 2&nbsp; &nbsp; Purchase Date&nbsp; &nbsp; Payment Date&nbsp;Table 3&nbsp; &nbsp; Return Date&nbsp; &nbsp; Acceptance Date&nbsp;Below is the diagram for easy referenceThanks&nbsp;&nbsp;&nbsp; &nbsp;

v-xicai · Accepted Answer

Hi CJ_96601&nbsp;,
&nbsp;
You can create a calculated table using DAX below, then create relationship with Calendar table.
&nbsp;
Date table= UNION(
SELECTCOLUMNS('Table1',"Date1",[Order Date ],"Date2",[Delivery Date ]),
SELECTCOLUMNS('Table2',"Date1",[Purchase Date],"Date2",[Payment Date]),
SELECTCOLUMNS('Table3',"Date1",[Return Date],"Date2",[Acceptance Date]))
Best Regards,
Amy
&nbsp;
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

Relationships

2 Replies

Related content

Relationship

Relationships

Relationship Issue

Creating relationships

PowerBI Relationships