Forum Discussion

WJ876400's avatar
WJ876400
Helper IV
6 years ago
Solved

If statement with different data types

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 T...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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's avatar
WJ876400
Helper IV
6 years ago

Hi Anonymous  i tried that but get the following error

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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's avatar
    WJ876400
    Helper IV
    6 years ago

    thanks very much that worked