Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.
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
)
Check out the May 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
17 | |
15 | |
14 | |
12 | |
11 |
User | Count |
---|---|
11 | |
10 | |
8 | |
7 | |
7 |