Forum Discussion
Solved
Power Query Function That Returns Value Based on Which Columns Have Data
Hi, In the past I came across a function that would return a value from either Column A, B, C, or D depending if which ones contain data. For example: Col A = USA Col B = CA Col C = Sa...
Hi sd_kevin
Try this function COALESCE().
e.g.
FYI: https://dax.guide/coalesce/
Best Regards,
Community Support Team _ Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Hi sd_kevin
Try this function COALESCE().
e.g.
FYI: https://dax.guide/coalesce/
Best Regards,
Community Support Team _ Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Thank you!! That was exactly what I was looking for!!