Forum Discussion
Urgent Help....!......Power Query Transformation
I need help in transforming the attached sample data into desired format as below.
Please extend your help
3 Replies
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-or-end-date/ba-p/1503785Tables 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-9ad6a84cf5f2Not sure why I am unable to attach the file here, but this is the sample file I have.
