Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am using the following Custom Column Formula to create a column of locations with address, city, state and zip code.
= [Injury Location Address1]&", "&[Injury Location City]&", "&[Injury Location State]&" "&[Injury Location Zip Code]
It almost works but I if one of the 4 location columns is null, it considers the whole address null for the custom column.
What can I do to the above formula or in a different way allow the address to show inmy custom column if at least one of the four has proper data.
Solved! Go to Solution.
I went ahead and Merged all 4 columns and that worked as expected as compared to my Custom Column.
I went ahead and Merged all 4 columns and that worked as expected as compared to my Custom Column.
I should have said I am not getting the partial addresses to show if there is a null value in any of the 4 column fields for a single addess.
Could the null values be the issue and I need to have the null show as blank or somethiing else so that I see what the column can merge?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |