DAX - Blank Data

[spandy34]

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?

Difference in Performance =

[Current Performance]-[Previous Performance] 

@tamerj1, @amitchandak, @danextian , @goncalogeraldes 

[DOLEARY85]

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 👍

[spandy34]

Sorry , I want to create a calculated column.  Please can you amend the DAX for a column.  Sorry

[DOLEARY85]

Can you share an example of what your data looks like, as it looks like the measure you referenced is made up of 2 other measures.

[spandy34]

[v-jingzhang · Accepted solution]

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.