How to convert my script 30000 till 39999 = COGS ?

[Anonymous]

Hi All

Below code no error , i like to modify :-

GL CODE  from 30000 till 39999 = COGS

Dax_Recode =

SWITCH(TRUE(),MAX('Table'[GL CODE])<=30000,"REVENUE",MAX('Table'[GL CODE])<=39999,"COGS",BLANK())

https://www.dropbox.com/s/eiwv63qqvol7o9c/GL_%20TDS%20v0002.pbix?dl=0

[Anonymous]

Can this work?

[Anonymous]

Hi Sir

Thank you for sharing .

The image very blur , I Cannot see your code . Basically i need some thing like below :-

Can you share how to write in PBI ?

If([GL Code]>=30000 and [GL Code]<=39999) as [COGS],

[Anonymous]

It's just removing max:

Dax_Recode =

SWITCH(TRUE(),

Sheet1[GL CODE]<=30000,"REVENUE",

Sheet1[GL CODE]<=39999,"COGS",

BLANK())

[Anonymous]

Hi Sir

I still get error :-

The syntax for 'Table' is incorrect. (DAX(SWITCH(TRUE(),Table[GL CODE]>=30000,"COGS",Table[GL CODE]<=39999,"COGS",BLANK()))).

https://www.dropbox.com/s/ibrj9aa1hmiqov4/GL_%20TDS%20v0006.pbix?dl=0

Above my PBI file

Paul Yeo

[Ashish_Mathur · Accepted solution]

Hi,

This calculated column formula works fine

Column = if(AND('Table'[GL CODE]>=30000,'Table'[GL CODE]<=39999),"COGS",BLANK())

Hope this helps.

[Anonymous]

Hi Ash

thank you very much it work fine now.

Paul

[Ashish_Mathur]

You are welcome.

[amitchandak]

@Anonymous , Create a new column, not measure

Dax_Recode =
SWITCH(TRUE(),('Table'[GL CODE])<=30000,"REVENUE",('Table'[GL CODE])<=39999,"COGS",BLANK())