Forum Discussion

eheres's avatar
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 ...
Data Protection
wdx223_Daniel's avatar
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's avatar
    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