Forum Discussion
DAX - Blank Data
I wondered if anyone could help me please.
I want the calculation to take subtract the Current Permance from Previous Performance but if the Previous performance is blank then i want to field to say " No Previous Data" How would I amend the DAX below please?
Hi spandy34
For a calculated column, the values returned should be in the same data type so your expected result cannot be achieved. Currently "[Current Performance]-[Previous Performance]" will return a number while " No Previous Data" is in Text type. Returning different types of values in a calculated column will give you the following variant-type error.
Please consider a different result when the Previous performance is blank. Or you can always convert "[Current Performance]-[Previous Performance]" result to Text type with CONVERT function.
Difference = IF ( ISBLANK ( [Previous Performance] ), "No Previous Data", CONVERT ( [Current Performance] - [Previous Performance], STRING ) )Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
5 Replies
Hi,
you could use: if(isblank([Difference in Performance]),"No Previous Data",[Difference in Performance])
or
COALESCE([Difference in Performance],"No Previous Data")If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
