Seek help on GL Mapping Code error msg

[Anonymous]

Hi All

Below is the script from another PBI file :-

Dax_Recode =

SWITCH(TRUE(),MAX('Table'[GL_CODE])<=9,"REVENUE",MAX('Table'[GL_CODE])<=19,"COGS",BLANK())

I paste to new measure , i get the error msg , may i know what does it mean ? How to correct ?

[amitchandak]

@Anonymous , You are creating a column. No need of MAX, Table name is wrong. Correct that

Dax_Recode =
SWITCH(TRUE(),('GL_CODE'[GL_CODE])<=9,"REVENUE",('GL_CODE'[GL_CODE])<=19,"COGS",BLANK())

[Anonymous]

Hi Amit

I have enter the correct Table name , when i paste your script , i have error .

[Anonymous]

@Anonymous  you can make use of this measure

Conditional column = if(Orders[Unit Price]<=7,"REVENUE",if(Orders[Unit Price]<=10,"PROFIT",BLANK()))

But replace  orders table name with your table name

[amitchandak · Accepted solution]

@Anonymous , You are creating a measure. You need a column in this case

[Anonymous]

Hi Amit

Thank you , it work now.