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 dataDateFleetSales Rep SicTypeValueDec-20M1576LSORIANOUnits10Dec-20M1882JOPEREZUnits2Dec-20M1206UQUINTANILLAUnits1Dec-20M1206UQUINTANILLAUnits5Jan-21M1576LSORIANOUnits8Jan-21M1882RCABRERAUnits2Jan-21M1206RFLORESUnits1Jan-21M1206RFLORESUnits5Feb-21M1576LSORIANOUnits7Feb-21M1882RCABRERAUnits2Feb-21M1206RFLORESUnits1Feb-21M1206RFLORESUnits5Mar-21M1576LSORIANOUnits6Mar-21M1882RCABRERAUnits2Mar-21M1206RFLORESUnits1Mar-21M1206RFLORESUnits5Apr-21M1576LSORIANOUnits5Apr-21M1206RFLORESUnits5May-21M1576LSORIANOUnits2May-21M1206RFLORESUnits5Jun-21M1206RFLORESUnits5Jul-21M1206RFLORESUnits5Aug-21M1576LSORIANOUnits2Aug-21M1882RCABRERAUnits2Aug-21M1206RFLORESUnits4Sep-21M1576LSORIANOUnits3Sep-21M1882RCABRERAUnits4Sep-21M1206RFLORESUnits3Oct-21M1882RCABRERAUnits4Oct-21M1206RFLORESUnits2Nov-21M1882RCABRERAUnits4Nov-21M1206RFLORESUnits2Dec-21M1882RCABRERAUnits4Dec-21M1206RFLORESUnits2Jan-22M1882RCABRERAUnits4Jan-22M1206FBALLESCAUnits1Feb-22M1882RCABRERAUnits4 Thank you!

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 oneFind the output screen Download pbix filehttps://drive.google.com/file/d/1MylQaOoGSrBw9aedZXJPWqcgeF9-K-Oh/view?usp=sharingIf solve your requirement, please mark this answer as SOLUTIONIf 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?

You need to do same type of Data Transformation for each sales person then combined (marged) into one tableAlso 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 wayIf solve your requirement, please mark this answer as SOLUTIONIf this comment helps you, please LIKE this comment/Kudos

eheres

Frequent Visitor

4 years ago

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

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!

Data Protection

9 Replies

PijushRoy
Community Champion
4 years ago
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
  Frequent Visitor
  4 years ago
  thanks but when i aplied to the other fleets it doesnt work 😞
  - PijushRoy
    Community Champion
    4 years ago
    If I create for all fleet, it will helps you?
wdx223_Daniel
Community Champion
4 years ago
create a date table, then create a relationship between the date column of these two table

and try this measure
- eheres
  Frequent Visitor
  4 years ago
  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