MIN multiples columns with blanks

Hersan — Thu, 16 Mar 2023 18:54:34 GMT

Hi everybody,

I did this code :

Délais plus peitit entre les trois possibilités =

MIN(MIN([Délai entre arrivée hemo et angioplastie], [Délai entre arrivée hemo et thrombectomie]),[Délai entre arrivée hemo et retour circulation])

To find the smaller time period between three columns, it was great when I got all the columns with data, but when there is a blank it doesn't work (see the image).

Thanks for your solutions!😁

Hersan

Re: MIN multiples columns with blanks

Greg_Deckler — Thu, 16 Mar 2023 19:28:20 GMT

Hersan Use MC Aggregations and filter out the blanks. Multi-Column Aggregations (MC Aggregations) - Microsoft Power BI Community

topic Re: MIN multiples columns with blanks in DAX Commands and Tips

MIN multiples columns with blanks

Re: MIN multiples columns with blanks