topic Re: MUltiple IF and statements in DAX Commands and Tips

MUltiple IF and statements

Jay2022 — Tue, 19 Dec 2023 10:32:56 GMT

Hi I keep getting Syntax errors when I try the following formula. Where am I going wrong

New_Column = IF('Table'[Store]= "A", "A",

IF('Table'[Store]= "B", "B",

IF('Table'[Store]= "C", && (‘Table’[Sales Date]<=TODAY(), “B”

IF('Table'[Store]= "D", && (‘Table’[Sales Date]<=TODAY(), “B”

IF('Table'[Store]= "C", && (‘Table’[Sales Date]>TODAY(), “C”

IF('Table'[Store]= "D", && (‘Table’[Sales Date]>TODAY(), “D”,” ”))

Re: MUltiple IF and statements

Dangar332 — Tue, 19 Dec 2023 15:56:24 GMT

Hi, Jay2022
Jay2022

try below code remove (" , ")

New_Column = IF('Table'[Store]= "A", "A", IF( 'Table'[Store]= "B", "B", IF('Table'[Store]= "C" && ‘Table’[Sales Date]<=TODAY(), “B”, IF('Table'[Store]= "D" && ‘Table’[Sales Date]<=TODAY(), “B”, IF('Table'[Store]= "C" && ‘Table’[Sales Date]>TODAY(), “C”, IF('Table'[Store]= "D" && ‘Table’[Sales Date]>TODAY(), “D”,” ”) )))))

or use switch() function

New_Column = switch(true(), 'Table'[Store]= "A", "A", 'Table'[Store]= "B", "B", 'Table'[Store]= "C" && ‘Table’[Sales Date]<=TODAY(), “B”, 'Table'[Store]= "D" && ‘Table’[Sales Date]<=TODAY(), “B”, 'Table'[Store]= "C" && ‘Table’[Sales Date]>TODAY(), “C”, 'Table'[Store]= "D" && ‘Table’[Sales Date]>TODAY(), “D”,” ” )

Re: MUltiple IF and statements

Jay2022 — Tue, 19 Dec 2023 14:43:26 GMT

Thank you

Re: MUltiple IF and statements

Dangar332 — Tue, 19 Dec 2023 16:06:02 GMT

Hi, Jay2022

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.