Forum Discussion

MaJar's avatar
MaJar
Frequent Visitor
1 year ago
Solved

Create an additive measure on a Date/Time column

Hello Experts,   I have 4 columns in my dataset that looks like the below: ID Created_Date Total_Duration_minutes Status 1 01/01/2025 07:00:00 120 Open 1 01/01/2025 07:00:00 60 V...
Need Help
  • muhammad_786_1's avatar
    muhammad_786_1
    1 year ago

    Hy MaJar 

    You can also get your desire output by using these 2 measures in your report.

     

    Total_Duration = SUM('Table'[Total_Duration_minutes])
    Date_After_Addition = MIN('Table'[Created_Date]) + ([Total_Duration] / 1440)

     

    Best Regards,
    Muhammad Yousaf

     

    If this post helps, then please consider "Accept it as the solution" to help the other members find it more quickly.

     

    LinkedIn

  • Fowmy's avatar
    Fowmy
    1 year ago

    MaJar 

    If you add the status in your visual, it will be part of the grouping, use the first DAX formula if you need to keep only one line per ID

Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
1 year ago

MaJar 

Measure for Total Duration:

Total Duration = SUM(Table1[Total_Duration_minutes])


Measure for Date_After_Addition:

Date_After_Addition = MAXX( VALUES(Table1[Created_Date]), Table1[Created_Date]) + TIME(0,[Total Duration],0)



 




MaJar's avatar
MaJar
Frequent Visitor
1 year ago

Hi,

 

Unfortunately, with this option, I loose the option to filter out the time spent on some status and the final time added will always be the same when I filter out some values.

 

Thank you!

  • Fowmy's avatar
    Fowmy
    Icon for Super User rankSuper User
    1 year ago

    MaJar 

    If you add the status in your visual, it will be part of the grouping, use the first DAX formula if you need to keep only one line per ID