Forum Discussion
Repeat values between periods
Hi All, Hope you can help me. I have to repeat the las t value between periods but onle ofr the people between that periods. Here is an example of what i got thats what i need ...
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/Kudos
yes but the thing is taht in my total data are more than 50 sales rep