Forum Discussion
Nested IF OR statement in Power Query
Hi Anonymous ,
Your greater signs and equal signs are not in the correct position, and you did not add double quotes to the fields after Then function.
So you can refer this following formula,
if [#"ReceievedDate - Time"] >= #time (0,0,0) or [#"ReceievedDate - Time"] < #time (1,0,0) then "00:00 - 01:00"If you have any question, please kindly ask here and we will try to resolve it.
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Ok so I've amended it to this, and it still comes back with the Token Then required error highlighting the "ti" in the first row of the word time.
Could either of you kindly script out how this should be written exactly using the first paragraph of my script? I'm getting something wrong somewhere and I just can't see it.
=if [#"ReceievedDate - Time"] => #time (0,0,0) or
[#"ReceievedDate - Time"] =< #time (1,0,0)
then 00:00 - 01:00
else
if [#"ReceievedDate - Time"] => #time (1,0,0) or
[#"ReceievedDate - Time"] =< #time (2,0,0)
then 01:00 - 02:00
else
if [#"ReceievedDate - Time"] => #time (2,0,0) or
[#"ReceievedDate - Time"] =< #time (3,0,0)
then 02:00 - 03:00
else
if [#"ReceievedDate - Time"] => #time (3,0,0) or
[#"ReceievedDate - Time"] =< #time (4,0,0)
then 03:00 - 04:00
else
if [#"ReceievedDate - Time"] => #time (4,0,0) or
[#"ReceievedDate - Time"] =< #time (5,0,0)
then 04:00 - 05:00
else
if [#"ReceievedDate - Time"] => #time (5,0,0) or
[#"ReceievedDate - Time"] =< #time (6,0,0)
then 05:00 - 06:00
else
if [#"ReceievedDate - Time"] => #time (6,0,0) or
[#"ReceievedDate - Time"] =< #time (7,0,0)
then 06:00 - 07:00
else
if [#"ReceievedDate - Time"] => #time (7,0,0) or
[#"ReceievedDate - Time"] =< #time (8,0,0)
then 07:00 - 08:00
else
if [#"ReceievedDate - Time"] => #time (8,0,0) or
[#"ReceievedDate - Time"] =< #time (9,0,0)
then 08:00 - 09:00
else
if [#"ReceievedDate - Time"] => #time (9,0,0) or
[#"ReceievedDate - Time"] =< #time (10,0,0)
then 09:00 - 10:00
else
if [#"ReceievedDate - Time"] => #time (10,0,0) or
[#"ReceievedDate - Time"] =< #time (11,0,0)
then 10:00 - 11:00
else
if [#"ReceievedDate - Time"] => #time (11,0,0) or
[#"ReceievedDate - Time"] =< #time (12,0,0)
then 11:00 - 12:00
else
if [#"ReceievedDate - Time"] => #time (12,0,0) or
[#"ReceievedDate - Time"] =< #time (13,0,0)
then 12:00 - 13:00
else
if [#"ReceievedDate - Time"] => #time (13,0,0) or
[#"ReceievedDate - Time"] =< #time (14,0,0)
then 13:00 - 14:00
else
if [#"ReceievedDate - Time"] => #time (14,0,0) or
[#"ReceievedDate - Time"] =< #time (15,0,0)
then 14:00 - 15:00
else
if [#"ReceievedDate - Time"] => #time (15,0,0) or
[#"ReceievedDate - Time"] =< #time (16,0,0)
then 15:00 - 16:00
else
if [#"ReceievedDate - Time"] => #time (16,0,0) or
[#"ReceievedDate - Time"] =< #time (17,0,0)
then 16:00 - 17:00
else
if [#"ReceievedDate - Time"] => #time (17,0,0) or
[#"ReceievedDate - Time"] =< #time (18,0,0)
then 17:00 - 18:00
else
if [#"ReceievedDate - Time"] => #time (18,0,0) or
[#"ReceievedDate - Time"] =< #time (19,0,0)
then 18:00 - 19:00
else
if [#"ReceievedDate - Time"] => (19,0,0) or
[#"ReceievedDate - Time"] =< (20,0,0)
then 19:00 - 20:00
else
if [#"ReceievedDate - Time"] => (20,0,0) or
[#"ReceievedDate - Time"] =< (21,0,0)
then 20:00 - 21:00
else
if [#"ReceievedDate - Time"] => (21,0,0) or
[#"ReceievedDate - Time"] =< (22,0,0)
then 21:00 - 22:00
else
if [#"ReceievedDate - Time"] => (22,0,0) or
[#"ReceievedDate - Time"] =< (23,0,0)
then 22:00 - 23:00
else 23:00 - 00:00Many Thanks
Anonymous
i'm not sure in your names. in marks "=<", in spaces after "time" and in then-statement. try like
=if [ReceievedDate - Time] => #time(0,0,0) or [ReceievedDate - Time] =< #time(1,0,0) then "00:00 - 01:00"
