Forum Discussion
MIN multiples columns with blanks
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
1 Reply
- Greg_Deckler
Community Champion
Hersan Use MC Aggregations and filter out the blanks. Multi-Column Aggregations (MC Aggregations) - Microsoft Power BI Community
