Forum Discussion
Sentencia IF OR anidada en Power Query
Hola Solo me pregunto si alguien podría ayudar con un error que estoy recibiendo de mi instrucción IF / OR de Power Query debajo de la cual estoy usando para obtener tiempos en un bucket de tiemp...
Ok, así que lo he enmendado a esto, y todavía vuelve con el token Luego se requiere el error de resaltado de la "ti" en la primera fila de la palabra tiempo.
¿Alguno de ustedes podría decir amablemente cómo esto debe escribirse exactamente usando el primer párrafo de mi guión? Me estoy equivocando en alguna parte y no puedo verlo.
=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:00Muchas gracias
