Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Dear All,
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.
Example
Table 1 Interval Match Calendar
Order Date Date Date
Delivery Date Year
Table 2
Purchase Date
Payment Date
Table 3
Return Date
Acceptance Date
Below is the diagram for easy reference
Thanks
Solved! Go to Solution.
Hi @CJ_96601 ,
You can create a calculated table using DAX below, then create relationship with Calendar table.
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
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @CJ_96601 ,
You can create a calculated table using DAX below, then create relationship with Calendar table.
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
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
hi @CJ_96601
If possible would you please share me sample file if it does not contain any sensitive data. or create small sample data and share so that i will try to solve the problem.
thanks,
Uzma
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |