topic Re: If Statements with Between Dates multi conditions in DAX Commands and Tips

If Statements with Between Dates multi conditions

Anonymous — Sun, 22 Jan 2023 20:52:42 GMT

Hello,

I would like to write a formula in a column that says:

IF(Open_Date, between 2021-01-01 and 2020-07-31 then 0%,

IF(Open_Date, between 2022-08-01 and 2022-12-31 then 2% * 1,
IF(Open_Date, between 2023-01-01 and 2023-31-12 then 3% * 1

Would anyone be able to assist me please?

Thanks,
D

Re: If Statements with Between Dates multi conditions

Greg_Deckler — Sun, 22 Jan 2023 21:52:08 GMT

Anonymous I would try something like this:

Column = SWITCH(TRUE(), [Open_Date] >= DATE(2020,7,31) && [Open Date] <= DATE(2021,1,1),0, [Open_Date] >= DATE(2022,8,1) && [Open Date] <= DATE(2022,12,31),.02*1, [Open_Date] >= DATE(2023,1,1) && [Open Date] <= DATE(2023,12,31),.03*1 )

Re: If Statements with Between Dates multi conditions

Anonymous — Sun, 22 Jan 2023 22:44:01 GMT

Greg_Deckler THANK YOU!!!!