Rolling data for a calculation

suppose we create a segment of users based on the number of transactions he has done and the latest transaction date. can we build something that has the rolling feature, like if the customer was available in x segment for the historical date 2022-01-01 and has moved to y segment today?

@shahkaran76 does this give you path forward? Rolling date feature

Hi, @shahkaran76. Did @Shekhar’s solution work for you? I am marking his reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community Q&A Forum!