Max over or running

[chgamez]

i’m trying to do this with:
maxOver(countIf({numero_de_credito},{cierre_semanal}={cierre_mensual}),[{cierre_mensual}])

[Max]

Hi @chgamez

What’s the question?

What’s off in your calculated field or numbers?

[chgamez]

Hi !

with this function: maxOver(countIf({numero_de_credito},{cierre_semanal}={cierre_mensual}),[{cierre_mensual}])

the result is this:

but the result should be this:

that is, the last data of the week, must be shown in the subsequent weeks of the following month

[duncan]

Hello @chgamez !

I am going to archive this topic since it has been open for an extended period of time. If you would still like assistance with this, or if you have a new QuickSight question, feel free to post a new topic in the community so you will be at the top of the priority list for a response from one of our QuickSight experts. Thank you!