Urgent Help....!......Power Query Transformation

[snaseem]

I need help in transforming the attached sample data into desired format as below.

Please extend your help

@amitchandak 

[snaseem]

[snaseem]

Not sure why I am unable to attach the file here, but this is the sample file I have.

[amitchandak]

@snaseem , I only see one screen shot. Please add both source and target. Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Check if these can help

Between Dates - Dates between
Measure way
Power BI Dax Measure- Allocate data between Range: https://youtu.be/O653vwLTUzM
https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-o...

Tables way
https://amitchandak.mediumcom/dax-get-all-dates-between-the-start-and-end-date-8f3dac4ff90b
https://amitchandak.medium.com/power-query-get-all-dates-between-the-start-and-end-date-9ad6a84cf5f2