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

MaJar's avatar
MaJar
Frequent Visitor
1 year ago

Hello Fowmy,

 

Thank you very much for your input.

 

I still need to have the ID and Status columns in my table. Once I add them into the table following your logic, the grouping doens't work and the measure are treating every row separately and not grouped by ID.

Can you advice what should I do to have the output table as I published in my post.

 

Thank you in advance

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

    MaJar 

    This should work:

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