I have a measure (Measure_A). When using Measure_A in the Value
field and a Timestamp in the Axis field, you get this graph:
I would like to find the MAX, MIN and AVG of the graphs values.
I have not been able to find anything useful and have not been able to make it work myself.
How do you do that?
Your help is highly appreciated.
Hi @M-M-P ,
You can turn to Analytics tab to use Min line, Max line and Average line.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Max Sales = CALCULATE(max(Sales[Sales]),ALLSELECTED())
Refer this for more details
Just to be sure. Is this correctly understood?
Max Sales = CALCULATE(max(Measure_A),ALLSELECTED())
If so, it complains that MAX needs a colum.
This is the measure.
Efficiency = VAR Input_1 = CALCULATE ( [Sum Value] , Data[Name] = "Input_1") VAR Output_1 = CALCULATE ( [Sum Value], Data[Name] = "Output_1") VAR Value_VG = CALCULATE ( [Sum Value] , Data[Name] = "Value_VG") VAR Efficiency = ((Value_VG - Input_1) / (Output_1 - Input_1)) * 100 RETURN IF(Efficiency< 0 , 0 , IF (Efficiency> 100 , 100 , Efficiency))
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Click here to read more about the July 2021 Updates
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.