CALCULATION BETWEEN DATES IN THE SAME COLUMN (NUMBER OF DAYS) | Sprint 005 [SOLUTION] POWER BI

Опубликовано: 14 Февраль 2026
на канале: Xperiun | Data Analytics
6,278
295

So, did you manage to solve this Sprint?

▶️ See the solution NOW! CALCULATION BETWEEN DATES IN THE SAME COLUMN | SPRINT 005 [SOLUTION] POWER BI

👇 What was your challenge? 👇
A ticket can have several statuses: open, in progress, under review, closed, among others. Your goal is to know how many days each ticket took to change status. The big detail is that the data doesn't have a start date column and an end date column; it only has a single date column indicating the start date of the new status.

In this video, I'll show you the step-by-step process using a Power BI Window Function to solve this challenge: OFFSET!

Ah, the Kickstart Challenge continues ▶️https://xperiun.com/sfunnel/284/?utm_...

I'm waiting for your solution!

#powerbi #dashboard #dax

===============================

📊 Enroll in the Complete Power BI Course, the largest and most advanced data analysis training on the market: https://xperiun.com/sfunnel/46/?utm_c...

👨‍💻 Talk to our experts to answer your training questions:

https://xperiun.com/sfunnel/51

=========================================
⬇️ ALSO WATCH ⬇️

Adding Flags to a Power BI Line Chart | Sprint 001 [SOLUTION]
   • Colocando Sinalizadores no Gráfico de Linh...  

SERVICE FLOW | Sprint 002 [SOLUTION]
   • FLUXO DE ATENDIMENTO | Sprint 002 [SOLUÇÃO]  

ACCOMPLISHED AND TARGET | Sprint 003 [SOLUTION] POWER BI
   • REALIZADO E META | Sprint 003 [SOLUÇÃO] PO...  

GROUPING QUARTERLY ON THE AXIS | Sprint 004 [SOLUTION] POWER BI
   • AGRUPANDO TRIMESTRE NO EIXO | Sprint 004 [...  

🔴 Live Challenge: Laboratory Service [SOLUTION]
https://youtube.com/live/9f7xZ68Svfs