Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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?
User | Count |
---|---|
118 | |
66 | |
65 | |
56 | |
50 |
User | Count |
---|---|
181 | |
85 | |
67 | |
61 | |
53 |