How to create last_n_week Flag ?

[ashmitp869]

Hi there,

How to create last_n_Flag of the Max([Reporting Date]) ?

Say for eg,

Max([Reporting Date]) = 30 Sep 2021

 last_n_Flag will be 18 Sep 2021 .

[AshutoshBhumkar]

Hi,

Maybe you can use WeekEnd() function to create flag.

E.g

Manipulate as per your requirement.

Thanks,

Ashutosh