Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
I have 2 different tables
1. Incidents
2. observations
Both have date fields
1. Incidents - Incident date
2. observations - Created Date.
Currently I am maintaining 2 date filters to filter incidents and observations. I want to merge date columns, so I can have one date filter.
Solved! Go to Solution.
Hi @Anonymous ,
You can create a Date table, then use this Date table to create a relationship with your two tables.
Here are some related articles:
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/
https://kohera.be/blog/power-bi/how-to-create-a-date-table-in-power-bi-in-2-simple-steps/
Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
You can create a Date table, then use this Date table to create a relationship with your two tables.
Here are some related articles:
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/
https://kohera.be/blog/power-bi/how-to-create-a-date-table-in-power-bi-in-2-simple-steps/
Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Dear @v-joesh-msft ,
I tried doing that, when I tried creating new relationship, Hierarchy in existing date columns disappears and creating new hierarchy doesnt works out.
Hi @Anonymous ,
This is the case, and accordingly, you can use the hierarchy in the Date table.
Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Create a Calendar Table by going to Modelling > New Table. Build a relationship from the Date column of both Tables to the Date column of the Calendar Table.
Hope this helps.
Dear @Ashish_Mathur,
"Relationship from the Date column of both Tables to the Date column of the Calendar Table", can u explain tis further?
Hi,
Read this - https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships
User | Count |
---|---|
94 | |
92 | |
85 | |
83 | |
49 |
User | Count |
---|---|
150 | |
146 | |
112 | |
73 | |
56 |