Replica datos

[jagarciao]

Hola a todos, 

No se como siguiente solucionar este problema, tengo la base, no se genera otra fila hasta que se actualiza el tiquet:

carné de identidad	Estado	Actualizacion
RFT937474	Pendiente	26/12/2020
RFT937474	Pendiente	01/01/2021

Requiero que quede de la siguiente forma:

Se agregaron los tres últimos registros con las fechas que correspondan al inicio de la semana del mes, hasta que el tiquet cambie de estado o de fecha de actualización.

carné de identidad	Estado	Actualizacion
RFT937474	Pendiente	26/12/2020
RFT937474	Pendiente	01/01/2021
RFT937474	Pendiente	01/04/2021
RFT937474	Pendiente	11/01/2021
RFT937474	Pendiente	18/01/2021

Gracias por su ayuda !!!

[AlB]

Hi @jagarciao 

You'll have to explain a bit more. There seem to be errors in the dates

- is  it 01/04/2020 or 04/01/2021 ?

- 11/01/2020??

plus it is not clear when to stop. There is no status change in your sample data.

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[jagarciao]

Ya se encuentra corregido, el limite lo pone una tabla calendario.

[v-yingjl]

Hi @jagarciao ,

Not certain what is your expected output. Did you want to insert rows in the source table which get each start date of week for each month?

In addition, what did calendar limits this represent? Could you please consdier sharing more details about this issue or a sample report without any sesentive information for further discussion?

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.