Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello everyone,
I'm trying to do some dynamic, row-wise calculations in Power BI.
1. I would like the measure to take a lower value out of two columns - "Period 1" and "Period 2".
So basically, I would like to have the following View in my table - "min value" is the desired output.
I was trying to achieve it with minx function, to calculate everything per row, for example:
- Minx(Table, [Period 1] & [period 2]) - but the returned result is not correct.
Thanks in advance for any help.
Solved! Go to Solution.
try to add a calculated column like:
Min value = MIN([Period 1], [Period 2])
@Pieter_parker with MINX as calulated column
Column =
MINX ( { { t1[p1] }, { t1[p2] } }, [Value] )
with MINX as measure
Measure 2 = MINX ( { { MIN(t1[p1]) }, { MIN(t1[p2]) } }, [Value] )
with MIN as measure
Measure = min(MIN(t1[p1]),MIN(t1[p2]))
@Pieter_parker with MINX as calulated column
Column =
MINX ( { { t1[p1] }, { t1[p2] } }, [Value] )
with MINX as measure
Measure 2 = MINX ( { { MIN(t1[p1]) }, { MIN(t1[p2]) } }, [Value] )
with MIN as measure
Measure = min(MIN(t1[p1]),MIN(t1[p2]))
@askpbiuser Sorry, could not reply earlier. You can do any of the following
This is what I needed, thank you!