Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |