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.
We have dates at the dimension level as well as the fact. Above the Dim dates should only calculate the unique start/end. Is there a way to do this with calculate or other function ? I thought about storing the dates in both dimension and fact then calculating DimDaysBetween then hding the dates in the dimension. It would be ideal to have all the dates in the fact table to avoid multiple calendars.
Solved! Go to Solution.
Read up on related vs relatedtable.
https://business-insights.net/2017/09/02/the-magic-of-related-relatedtable-functions-in-dax/
Since I want to go from the fact to the dimension, I need to use RELATEDTABLE
Next step is to aggregage SLA over the context.
Read up on related vs relatedtable.
https://business-insights.net/2017/09/02/the-magic-of-related-relatedtable-functions-in-dax/
Since I want to go from the fact to the dimension, I need to use RELATEDTABLE
Next step is to aggregage SLA over the context.
Hi
I have done something similar in another context, but maybe you can use it here.
avg = AVERAGEX( SUMMARIZE(FactTable, FactTable[DimStartDate], FactTable[DimEndDate], FactTable[DimDaysBetween]), FactTable[DimDaysBetween]) sum= SUMX( SUMMARIZE(FactTable, FactTable[DimStartDate], FactTable[DimEndDate], FactTable[DimDaysBetween]), FactTable[DimDaysBetween])
If it works then please mark it as the solution.
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 |
---|---|
112 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |