Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowGet certified as a Fabric Data Engineer: Check your eligibility for a 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700. Get started
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!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
16 | |
15 | |
13 | |
12 | |
11 |