Forum Discussion
Solved
IF Function when date is empty (5 Columns)
Hi, I have 5 columns with different dates. I need a function that: IF Column Date1 is empty, take Column Date2, and if this one is empty, take Column Date3 and if this one is empty, take...
ngarcia you can use COALESCE function
COALESCE ( Table 1[Date1], Table 1[Date2], Table 1[Date3], Table 1[Date4], Table 1[Date5] )👉 Learn Power BI and Fabric - subscribe to our YT channel - @PowerBIHowTo
ngarcia you can use COALESCE function
COALESCE ( Table 1[Date1], Table 1[Date2], Table 1[Date3], Table 1[Date4], Table 1[Date5] )
👉 Learn Power BI and Fabric - subscribe to our YT channel - @PowerBIHowTo
Thank you heaps! this worked!