Skip to content

Instantly share code, notes, and snippets.

@Erik-H-zz

Erik-H-zz/Threshold (average past 5).dax

Created December 9, 2020 09:47
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Erik-H-zz/6bbd597788bafbd759c0e01d4564f595 to your computer and use it in GitHub Desktop.
Save Erik-H-zz/6bbd597788bafbd759c0e01d4564f595 to your computer and use it in GitHub Desktop.
Download ZIP
Average op TopN 5
Raw
Threshold (average past 5).dax
Threshold (average past 5) =
VAR top5 = TOPN( 5, RealTimeData , RealTimeData[Time] , DESC)
RETURN
CALCULATE(AVERAGE(RealTimeData[CPU]) , top5 )
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment