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.
Hi friends,
It looks quite simple and it works when I apply the "IF" function on the "Date" column to perform an operand on column 'kWh' as shown below. However, I have no success when I add multiple criteria to 'Date' for example I want to do this multiplication only for 3 days and my code is as below but the 'New column' comes with "Error"
if [date]=#date(2021,05,02) or [date]=#date(2021,05,03) then [kWh]*1000 else [kWh]
any idea please!
Solved! Go to Solution.
Thanks, Vera, I think I solved it with expanding it into multiple 'else' and 'if' 🙂
Thanks, Vera, I think I solved it with expanding it into multiple 'else' and 'if' 🙂
Hi @Alirezam
What is the error? I saw your Date column was typed [date] here, is it the reason? M is case sensitive
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 |
---|---|
100 | |
54 | |
21 | |
12 | |
11 |