If value is blank then value from other column should be displayed

[kulkarnipriya87]

Want to create one conditional column.

Condition is when INCI Name is blank then Value from description should be displayed.

Blank INCI = IF(IsBLANK('Item'[INCI Name]),'Item'[Description],'Item'[INCI Name])

I have tried this but couldn't work.

[devesh_gupta · Accepted solution]

@kulkarnipriya87 Firstly, Ensure that both 'INCI Name' and 'Description' have compatible data types. For example, they should both be of type text or similar. Verify that there are actual blank values in the 'INCI Name' column. Sometimes, what appears to be blank might actually be a whitespace or non-breaking space.

Your DAX expression looks fine but if it's still not working, try this:

Blank INCI = IF('Item'[INCI Name] = BLANK(), 'Item'[Description], 'Item'[INCI Name])

Let me know if it works for you.

If you find this insightful, please provide a Kudo and accept this as a solution.

[kulkarnipriya87]

Thanks, It works.