Create Flag for Last 2 weeks of data.

[damit23183]

Hi,

I would like to create flag for current max week and last week data only.

For example, I have this table -

I would like to create dynamic flag like this 

However, next week it should be look like this;

Thus, every week flag will change based on max current week and previous week of max week.

Any help will be appreciated.

I have tried following solution;

1) Rankx

2) Create variable with max week then compare with dim date table.

3)Swithc function with max week = week from dim_date && max week-7 = week from Dim_Date-7.

Thank you in advance!

[danextian · Accepted solution]

hI @damit23183 ,

Please try this:

Flag =
VAR __MAX_WEEK =
    MAX ( 'Table'[Week] )
RETURN
    __MAX_WEEK - 'Table'[Week] <= 7

[damit23183]

Hi,

Thank you for your response and solution that worked perfectly fine.

Thanks