Forum Discussion
Repeat values between periods
Hi eheres
I use one sales person for sample. You need to create reference table in PQ and need to run same steps.
After that you need to Append the all salesman wise table into one
Find the output screen
Download pbix file
https://drive.google.com/file/d/1MylQaOoGSrBw9aedZXJPWqcgeF9-K-Oh/view?usp=sharing
If solve your requirement, please mark this answer as SOLUTION
If this comment helps you, please LIKE this comment/Kudos
thanks but when i aplied to the other fleets it doesnt work 😞
If I create for all fleet, it will helps you?
yes please 🙂
You need to do same type of Data Transformation for each sales person then combined (marged) into one table
Also some times you need to use FilledUp and some time FilledDown (look power query steps)
Also I found, one sales person having two rows data in same month. For this case, you need to use Group by fundction to shape proper way
If solve your requirement, please mark this answer as SOLUTION
If this comment helps you, please LIKE this comment/Kudosyes but the thing is taht in my total data are more than 50 sales rep
eheres
We need to apply similar types of steps for other fleet. As all fleets data are not same, please find my previous comment.
Some sales person only have data for 1.12.2020
where another sales person having two rows data for one particular month.
I am sharing steps and pbix, to understand what you need to do
Use filledUP and filledDown option, as per requirement
If solve your requirement, please mark this answer as SOLUTION
If this comment helps you, please LIKE this comment/Kudos
