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.
Hi
I have a calendar table with date and some other calculated columns such as year, quarter, month name etc...
In my data model so many tables are available with lot of date fields. So when I relate the Date field from calendar table to other table date's some data is not showing properly due to the relationship issue
My Query is
Is there any possibility to create measures and through passing parameters in each of the table, creating measures which helps to avoid the relationship between calendar table and other tables
Solved! Go to Solution.
Create the relationships and make them as inactive. For any relationship that you want to activate using a measure, use userelationship in your measure.
https://docs.microsoft.com/en-us/dax/userelationship-function-dax
Create the relationships and make them as inactive. For any relationship that you want to activate using a measure, use userelationship in your measure.
https://docs.microsoft.com/en-us/dax/userelationship-function-dax
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 |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |