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],""))

Anonymous's avatar
Anonymous
Not applicable
6 years ago

WJ876400 

Column = IF('Table'[Start Year]="2016/17","NA",FORMAT('Table'[Progression 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

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

  • 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