If statement with different data types

[WJ876400]

Hi

I want to create a new column or measure that looks at two colums with different data types and returns a value.

I want to re create the below. The start year is TEXT and the progression Target is decimal number. I want the progression column to populate based on -

If the start year is 2016/17 then return NA or blank, if it is anything else return the progression target. Any help would be appreciated, thank

Start Year	Progression Target	Progression
2016/17	5.6	NA
2016/17	2.8	NA
2016/17	3.7	NA
2017/18	7.5	7.5
2018/19	5.2	5.2

[Anonymous]

@WJ876400 

Column = IF('Table'[Start Year]="2016/17","NA",FORMAT('Table'[Progression Target],""))

[WJ876400]

Hi @Anonymous  i tried that but get the following error

[Anonymous]

@WJ876400You forgot the "" in the FORMAT function second argument.

[Anonymous · Accepted solution]

@WJ876400 You are missing second argument of format function 

try this

IF(learners[ACADEMIC START YEAR]="2016-2017","NA",FORMAT(Learners[OJT_Target.CURRENT OJT TARGET],""))

[WJ876400]

thanks very much that worked

[Anonymous]

Hi @WJ876400 ,

Is that a single DB table?

BR,

DR

[WJ876400]

Hi

It is from two spreadsheets merged in the query

thanks