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'm not very good to Power Query and I don't know why it doesn't work :
if [Order created] >= 2022-01-01 & [Order created] <= 2022-12-31 then 1 else 0
Thank you for your help
Solved! Go to Solution.
if[Date] >= #date(2022,01,01) and [Date] <= #date(2022,12,31)then 1 else 0
if[Date] >= #date(2022,01,01) and [Date] <= #date(2022,12,31)then 1 else 0
This didn't work for me, the entire formula worked until I put text in after then.
Could you take a look and see if you know the solution:
IF ([CancelTime] - [StartTime]) >= Time.Minute(10) and Time.Minute (18) then "Yes" else ""
only the "Yes" is failing and I can't seem to resolve it.
Without seeing the data it's difficult to give a correct answer. If you keep the calculation within one set of brackets maybe it will work?
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |