Forum Discussion
3 Step IF statement or Switch
Hi,
After reading through several threads I got stuck and didnt manage to solve this on my own 😕 But hey, here's to a great community right! 🙂
I have three sets of columns, A, B and C.
What I want to achieve:
I want PBI to populate column D with the info coming from either A, B or C.
So in all simplicity;
If column A = blank and Column B is blank, then populate Column D with Column C.
If Column B = blank and Column C is blank, then populate Column D with Column A.
If Column C = blank and Column A is blank, then populate Column D with Column B.
With only two columns its not difficult at all, but three...well, I surrender 🙂
Any help appreciated!
Hi tonijj ,
If you only have values in one of the columns try the following code:
Output = COALESCE ( Table[ColumnA], COALESCE ( Table[ColumnB], Table[Column C])Be aware that the first value to be check will be the Column A then B then C so if you have two columns with values they will be pick up by that order.
3 Replies
Hi tonijj ,
If you only have values in one of the columns try the following code:
Output = COALESCE ( Table[ColumnA], COALESCE ( Table[ColumnB], Table[Column C])Be aware that the first value to be check will be the Column A then B then C so if you have two columns with values they will be pick up by that order.
Hi MFelix
Thanks! That seems to work!
Quick followup question; Why would I need to use Coalesce twice?
In the formula above its used as main DAX function, but then within the formula, after [ColumnA] again? Just wondering wether thats a typo or if Im missing something? Just asking so I learn how to use it myself next time 🙂
