Repeat values between periods

[eheres]

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

Here is the table with the data

Date	Fleet	Sales Rep Sic	Type	Value
Dec-20	M1576	LSORIANO	Units	10
Dec-20	M1882	JOPEREZ	Units	2
Dec-20	M1206	UQUINTANILLA	Units	1
Dec-20	M1206	UQUINTANILLA	Units	5
Jan-21	M1576	LSORIANO	Units	8
Jan-21	M1882	RCABRERA	Units	2
Jan-21	M1206	RFLORES	Units	1
Jan-21	M1206	RFLORES	Units	5
Feb-21	M1576	LSORIANO	Units	7
Feb-21	M1882	RCABRERA	Units	2
Feb-21	M1206	RFLORES	Units	1
Feb-21	M1206	RFLORES	Units	5
Mar-21	M1576	LSORIANO	Units	6
Mar-21	M1882	RCABRERA	Units	2
Mar-21	M1206	RFLORES	Units	1
Mar-21	M1206	RFLORES	Units	5
Apr-21	M1576	LSORIANO	Units	5
Apr-21	M1206	RFLORES	Units	5
May-21	M1576	LSORIANO	Units	2
May-21	M1206	RFLORES	Units	5
Jun-21	M1206	RFLORES	Units	5
Jul-21	M1206	RFLORES	Units	5
Aug-21	M1576	LSORIANO	Units	2
Aug-21	M1882	RCABRERA	Units	2
Aug-21	M1206	RFLORES	Units	4
Sep-21	M1576	LSORIANO	Units	3
Sep-21	M1882	RCABRERA	Units	4
Sep-21	M1206	RFLORES	Units	3
Oct-21	M1882	RCABRERA	Units	4
Oct-21	M1206	RFLORES	Units	2
Nov-21	M1882	RCABRERA	Units	4
Nov-21	M1206	RFLORES	Units	2
Dec-21	M1882	RCABRERA	Units	4
Dec-21	M1206	RFLORES	Units	2
Jan-22	M1882	RCABRERA	Units	4
Jan-22	M1206	FBALLESCA	Units	1
Feb-22	M1882	RCABRERA	Units	4

Thank you!

[wdx223_Daniel]

create a date table, then create a relationship between the date column of these two table

and try this measure

[eheres]

Thank you daniel it works great but i have to mantain the seasonality of the fleet by sales rep, for example in the fleet 1882 JOPEREZ has to be only in Dec 20 but from Jan21 to Feb 22 has to be only RCABRERA

[PijushRoy]

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

[eheres]

thanks but when i aplied to the other fleets it doesnt work 😞

[PijushRoy]

@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

[PijushRoy]

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

[eheres]

yes but the thing is taht in my total data are more than 50 sales rep

[PijushRoy]

If I create for all fleet, it will helps you?

[eheres]

yes please 🙂