Identical Dates with YTD running totals

[test_123_e213]

I want to compute a ytd that can be seen with the total increasing after each date where a new DLY occurs. 

Any direction or advice would be greatly appreciated since the YTD function cannot be run with identical dates. ! I've tried many things so far with creating a new date table but it is causing me issues, maybe on how I connected the two queries.

I suppose the end result would look something like this. Anything I would be able to select a date and see the YTD.

Thanks,

Lucas

[v-frfei-msft]

Hi @test_123_e213,

One sample for your reference. If it doesn't meet your requirement, kindly share your excepted result to me.

Regards,

Frank

[test_123_e213]

Thanks for your help too!

Both answers were the same but it was still nice to see. 

Lucas

[dedelman_clng · Accepted solution]

Based on your sample data (there is no DLY value to total on?), you can add a column stripping off the time, then do TOTALYTD off of that column

Column

Dt = DATEVALUE(DurTab[DLY_ST])

Measure

YTD = TOTALYTD(SUM(DurTab[DLY_DUR]), DurTab[Dt])

Hope this helps

David