Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi experts,
I need help with a measure that gives me the average output for the last 30 days.
The Measure i need a 30 days average for is the following
Measure:= DIVIDE([Water];[Wastewater])
Where the Water is the following measure
water:= SUMX ( 'Table1'; 'Table1'[Amount] * 'Table1'[conversion factor] )
And wastewater is the following measure
Watewater:= CALCULATE ( SUM ( 'Table1'[Amount] ); Table2[Reference] IN { "X1" } )
Solved! Go to Solution.
I Found a solution
Measure := CALCULATE ( AVERAGEX ( SUMMARIZE ( 'Table1; Date[Dato]; "flow"; [Measure1] ); [Mesure1] ); FILTER ( ALL ( DAte[Dato] ); Date[Dato] > TODAY () - 32 ) )
I Found a solution
Measure := CALCULATE ( AVERAGEX ( SUMMARIZE ( 'Table1; Date[Dato]; "flow"; [Measure1] ); [Mesure1] ); FILTER ( ALL ( DAte[Dato] ); Date[Dato] > TODAY () - 32 ) )
Measure2 = VAR tday= TODAY() VAR tday_2 = tday-30 Return CALCULATE( AVERAGE([Measure]), 'Calendar'[Date] <= tday, 'Calendar'[Date] >= tday_2 )
i can't take the aveage of a measure in the function
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |