Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
Basically I have 3 country column(Country 1,Country 2 and Country 2) like below. How can I write the conditional column in the power query to produce the Country column based on the conditional column on Country 1, Country 2 and Country 3. Kindly please help.
Country 1 | Country 2 | Country 3 | Country |
null | Malaysia | Malaysia | Malaysia |
blank | Malaysia | null | Malaysia |
Brunei | null | null | Brunei |
Thanks and Regards,
Hopes.
Solved! Go to Solution.
reHi @Fathopes ,
you add a column with this forumla
List.Select ( { [Country 1], [Country 2], [Country 3] }, (l) => l <> null and l <> "") {0}
It grabs the first value from the column at is neither null nor blank.
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
reHi @Fathopes ,
you add a column with this forumla
List.Select ( { [Country 1], [Country 2], [Country 3] }, (l) => l <> null and l <> "") {0}
It grabs the first value from the column at is neither null nor blank.
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries