Hello Every one
I need to take the min hour in some colums, but some of them are null, so when i use the min expression takes the null value as the min, so i need to evaluate only the rows wich are not blank.
My calculated column is
Min =MIN(MIN(BLOQ[Bloq_Entrega];BLOQ[Bloq_credito]);BLOQ[Bloq_comer])
but my result is still blank, even I I have two colums with data
Please I need your Help!
Solved! Go to Solution.
@Anonymous
USe this Calc column
Min = VAR temp = { [Bloq_Entrega], [Bloq_credito], [Bloq_comer] } RETURN MINX ( FILTER ( temp, [Value] <> BLANK () ), [Value] )
@Anonymous
USe this Calc column
Min = VAR temp = { [Bloq_Entrega], [Bloq_credito], [Bloq_comer] } RETURN MINX ( FILTER ( temp, [Value] <> BLANK () ), [Value] )
Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.
Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!
User | Count |
---|---|
209 | |
52 | |
43 | |
41 | |
39 |
User | Count |
---|---|
269 | |
210 | |
73 | |
70 | |
65 |