Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
@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
)
@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
)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
43 | |
20 | |
20 | |
16 | |
15 |
User | Count |
---|---|
46 | |
28 | |
25 | |
18 | |
17 |