FY quarter wise opening, current quarter all transaction, Opening+transactions as closing

[Naveen58]

we have data as daily transactions, fiscal Quarter in our data. we need data in matrix as

	FY Q1	FY Q2	FY Q3	FY Q4
Opening for Quarter	10	13	18	20
transaction 1	1	3	1	4
transaction 2	2	2	1	1
Closing for Quarter	13	18	20	25

Please help us in this Usecase.

[foodd]

Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question completely in a usable format (not as a screenshot).

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.

[Naveen58]

Dear Foodd,

Please find attached sample data.

https://ubplhub-my.sharepoint.com/:x:/g/personal/somarouthu_jaideep_uneecops_com/EZHST_3uYPFAkN7-u38...

PBI File - 

https://ubplhub-my.sharepoint.com/:u:/g/personal/somarouthu_jaideep_uneecops_com/Ebtt3_Z0h7BIm6MgscA...