Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hola a todos, esta es probablemente una solución bastante fácil, pero no puedo entenderlo. ¿Cómo puedo tomar la lógica de la expresión DAX siguiente y aplicarla en power query?
Status =
IF (
ISBLANK ( 'Table1'[Complete Date] ),
IF ( 'Table1'[Due Date] < TODAY (), "Overdue", "Open" ),
IF (
'Table1'[Complete Date] > 'Table1'[Due Date],
"Closed - Delayed",
"Closed - On Time"
)
)
Gracias de antemano
Solved! Go to Solution.
@CaveOfWonders
Agregar una columna personalizada en PQ:
if [Complete Date] = null then
if [Due Date] < Date.From(DateTime.LocalNow()) then "Overdue" else "Open" else
if [Complete Date] > [Due Date] then
"Closed - Delayed" else "Closed - On Time"
Gracias 🙂
@CaveOfWonders
Agregar una columna personalizada en PQ:
if [Complete Date] = null then
if [Due Date] < Date.From(DateTime.LocalNow()) then "Overdue" else "Open" else
if [Complete Date] > [Due Date] then
"Closed - Delayed" else "Closed - On Time"
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
1 | |
1 | |
1 | |
1 | |
1 |