I"m building a dashboard that will identify missing values for three data points: Billing, Reason, Origin. They are all text and do not contain numbers.

How do I construct a calculated column I can use with a visual to display the missing information?

Here is the mess I created that is not working:

Missing Values = IF(
Dataset[Billing] = "" || Dataset[Billing] = BLANK(),
"Missing Billing",
Dataset[Billing] &&

IF(
Dataset[Reason] = "" || Dataset[Reason] = BLANK(), || Dataset[Reason] = BLANK(),
"Missing Reason",
Dataset[Reason] && 
    
IF(
Dataset[Origin] = "" || Dataset[Matter Origin] = BLANK(),
"Missing Origin",
Combined[Origin]

)

I'm expecting the column to display what is missing from each row.

Ultimately, I'd like the data to be displayed like this after I figure out how to create the column so I can create the visual.

dashboard concept