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.
Hola
Tengo esta fórmula en BO, pero recibo un error al convertir a PBI.
Intervalo de fechas
=Si [Días para la aprobación] = "No aprobado" entonces [Días para la aprobación]
ElseIf ([Días para la aprobación (numérico)]> =0 y [Días para la aprobación (numérico)] < = 3) Entonces "0 - 03 días"
ElseIf ([Días para la aprobación (numérico)] > 3 y [Días para la aprobación (numérico)] < = 7) Luego "04 - 07 días"
ElseIf ([Días para la aprobación (numérico)] > 7 y [Días para la aprobación (numérico)] < = 15) Luego "08 - 15 días"
ElseIf ([Días para la aprobación (numérico)] > 15 y [Días para la aprobación (numérico)] < = 30) Luego "16 - 30 días"
ElseIf [Días para la aprobación (numérico)] > 30 y luego "más de 31 días"
Gracias por los comentarios.
Solved! Go to Solution.
Usa esto
Date Range =
SWITCH(
TRUE(),
[Days for Approval] = "Not Approved", [Days for Approval],
[Days for Approval (Numeric)]>=0 && [Days for Approval (Numeric)] <=3, "0 - 03 Days",
[Days for Approval (Numeric)] > 3 && [Days for Approval (Numeric)] <= 7 , "04 - 07 Days",
[Days for Approval (Numeric)] > 7 && [Days for Approval (Numeric)] <= 15 , "08 - 15 Days",
[Days for Approval (Numeric)] > 15 && [Days for Approval (Numeric)] <= 30, "16 - 30 Days",
[Days for Approval (Numeric)] > 30 , "31+ Days"
)
Funcionó. Gracias. 🙂
Usa esto
Date Range =
SWITCH(
TRUE(),
[Days for Approval] = "Not Approved", [Days for Approval],
[Days for Approval (Numeric)]>=0 && [Days for Approval (Numeric)] <=3, "0 - 03 Days",
[Days for Approval (Numeric)] > 3 && [Days for Approval (Numeric)] <= 7 , "04 - 07 Days",
[Days for Approval (Numeric)] > 7 && [Days for Approval (Numeric)] <= 15 , "08 - 15 Days",
[Days for Approval (Numeric)] > 15 && [Days for Approval (Numeric)] <= 30, "16 - 30 Days",
[Days for Approval (Numeric)] > 30 , "31+ Days"
)
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 |
---|---|
2 | |
2 | |
2 | |
2 | |
1 |