Measure to calculate period change with custom time periods

[Anonymous]

Hi,

I am looking to calculate activity to catch the total time spent on a project but the data that I receive is not ideal.  

I need to be able to calculate the cumulative change from the prior custom period.

The data is set up like this  

User	Project	Minutes	Time Period	Week	Cumulative Minutes
1	A	54.016666	2012-P11	3	54.016666
1	A	107.783331	2023-P1	1	53.766665
1	A	298.68333	2023-P1	2	190.899999
1	A	359.516665	2023-P2	3	60.833335
					359.516665
The results should just take the change from the prior period and I don't want to include the normal date structure that I see in typical examples.
Desired Result
			2012-P11		54.016666
			2023-P1		244.666664
			2023-P2		60.833335
			Total		359.516665

[Anonymous]

I appreciate the quick response but this doesn't really seem to help.  I still get to the place where it works at year-period-week but not at a year-period.  

I even tried to just add an index for each year-period and that doesn't work either.

Any thoughts?

[amitchandak]

@Anonymous , You need use rank on YYYYPP and then use that for POP

Power BI Custom Period Till Date (PTD)- https://youtu.be/rQ3Z_LtxwQM

Time Intelligence, Part of learn Power BI https://youtu.be/cN8AO3_vmlY?t=27510
Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date: https://youtu.be/aU2aKbnHuWs&t=145s