Calculating actual time spent on appointment

[ludvigreck]

Hello,

I need help to calculate the following problem

TIA,

Ludvig Reck

[ludvigreck]

Fantastic, thank you!

[SamWiseOwl · Accepted solution]

Hi @ludvigreck 

You can use variable to capture the data for the current row.

Return the smallest date in the table after filter to appointments after.

Then do an IF between the two:

Time Diff calc =

var star = --Capture current app time

SELECTEDVALUE('Table'[Appointment Time])

VAR DUR = --Capture current duration

SELECTEDVALUE('Table'[Duration])

var nextStar = --Calculate next start

CALCULATE(

    min('Table'[Appointment Time])

    ,ALLSELECTED('Table')

    ,'Table'[Appointment Time] > star)

var TimeDiff = DATEDIFF(star,nextStar,MINUTE)

var final =

IF(

    TimeDiff < DUR --if time diff shorter 

     ,TimeDiff --return diff

     ,DUR

)

Return final 

[ludvigreck]

Hello Sam,

Thanks for the input,

We have this table in a data warehouse in Fabric. Do you know how to use this dax code to handle the transformation at the data warehouse-level, before data enters Power BI?

All the best,

Ludvig