Cumulative YTD Measure

[aflintdepm]

I have a request to generate a report that shows the cumulative YTD by day.

All data is in the same table.  I have a column Task Name that has the different tasks being counted, and I have a Task Date column that represents the date the task was performed.

The desired output would be a matrix that looks like this

Task Name	3/1/24	3/2/24	3/3/24	3/4/24	3/5/24	3/6/24
Task 1	500	508	513	525	532	540
Task 2	405	420	435	441	460	475
Task 3	600	621	628	640	652	661

How do I create a measure to accomplish this?

[Greg_Deckler · Accepted solution]

@aflintdepm Better Year to Date Total - Microsoft Fabric Community