Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Holaaa, necesito ayuda en sacar la fecha min entre 4 columnas. El ejemplo sería:
primera fecha segundafecha tercera fecha cuartafecha
2018/03/05 2015/05/20 2011/04/05 2021/02/15
El resultado entre la cuatro columnas debe de arrojar 2011/04/05,
Agradezco la ayuda.
Gracias
Solved! Go to Solution.
Hi @tatac1412 ,
According to your description, I create a sample.
Here's my solution, create a measure.
Min =
VAR _T =
UNION (
VALUES ( 'Table'[Column1] ),
VALUES ( 'Table'[Column2] ),
VALUES ( 'Table'[Column3] ),
VALUES ( 'Table'[Column4] )
)
RETURN
MINX ( _T, [Column1] )
Get the correct result.
I attach my sample below for reference.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @tatac1412 ,
Do you mean if there is a column has blank value like this:
By my test it does not affect the final result, it still get the min value in this scenario.
Best Regards,
Community Support Team _ kalyj
Hi @tatac1412 ,
According to your description, I create a sample.
Here's my solution, create a measure.
Min =
VAR _T =
UNION (
VALUES ( 'Table'[Column1] ),
VALUES ( 'Table'[Column2] ),
VALUES ( 'Table'[Column3] ),
VALUES ( 'Table'[Column4] )
)
RETURN
MINX ( _T, [Column1] )
Get the correct result.
I attach my sample below for reference.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Muchas gracias por la solución, me puedes indicar también es esa medida como hago para que si en alguna de esas columnas esta vacia no tome ese campo como menor fecha??
Min = VAR _T = UNION ( VALUES ( 'Table'[Column1] ), VALUES ( 'Table'[Column2] ), VALUES ( 'Table'[Column3] ), VALUES ( 'Table'[Column4] ) ) RETURN MINX ( _T, [Column1] )
porque tengo campos vacios y la formula los arroja como fecha menor.
Gracias
Hi @tatac1412 ,
Do you mean if there is a column has blank value like this:
By my test it does not affect the final result, it still get the min value in this scenario.
Best Regards,
Community Support Team _ kalyj
Muchas gracias por la solución, te pregunto si en una de esas 4 columnas de fechas hay por ejemplo 1800/01/01 como fecha comodín como hago para que la función no la tome como fecha minima sino que coja otra fecha ; ejemplo colum 1(2001/08/05) colum2( 2011/04/17) colum3(1800/01/01 ) colum4(2022/05/09)
el resultado será 2001/08/05. Agradezco la ayuda. gracias
@tatac1412 , Try
Minx({[Col1],[Col2],[Col3],[Col4]}, [Value])
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
23 | |
21 | |
20 | |
13 | |
12 |
User | Count |
---|---|
43 | |
31 | |
24 | |
23 | |
22 |