DAX calculations, min value out of two columns.

[Pieter_parker]

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. 

[FreemanZ · Accepted solution]

hi @Pieter_parker 

try to add a calculated column like:

Min value = MIN([Period 1], [Period 2])

[smpa01 · Accepted solution]

@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]

Hi @smpa01 -
Thank you for your answer. I have a similar issue and used the measure (measure 2) and got the right values. However I do get wrong row totals. Just like in your screenshot as you have 100 and ideally it should be 400. How can I fix this?

Maybe @FreemanZ could also help here 🙂

[smpa01]

@askpbiuser  Sorry, could not reply earlier. You can do any of the following

[FreemanZ · Accepted solution]

hi @Pieter_parker 

try to add a calculated column like:

Min value = MIN([Period 1], [Period 2])

[Pieter_parker]

This is what I needed, thank you!