How to create Flag to trigger Jan till July when today is 3 Aug ?

[admin11]

Hi All

I have a Date field , MONTH2 = FORMAT('DATE'[Date],"MM")

It display at my report page , for user to select month .

I like to crate a expression for Flag_not_current_month.

For example if now is Aug , when i trigger the Flag_not_current_month , it will select Jan till July.

The expression should look some thing like below :-

Flag_not_current_month = IF ('DATE'[Date] >= EDATE(TODAY(),-7), 1, 0)

Remark :- When Today is 3 Sept , when i trigger Flag_not_current_month , it should select Jan till Aug.

Now user need Click 8 time , in order to turn on Jan till Aug.

Paul

[lukiz84]

when you add your expression as a calculated column it's refreshed everytime the model is updated... what do you need to do manually?

[admin11]

@lukiz84 

Thank you for look into my post.

what I need is for example :- 

Now is Aug , it will Flag Jan till July avoid Aug

For example now is Sept , it will flag Jan till Aug , Avoid Sept.

I cannot think of expression can do this . 

paul

[v-easonf-msft]

Hi, @admin11 

If you're referring to automatically changing multi-select values in slicers, it's not currently supported.

Best Regards,
Community Support Team _ Eason

[lukiz84]

Just add your expression to the Date table and add the calculated column as a slicer.

[admin11]

@lukiz84 @The issue is my expression not dynamic. Every month I need to manual modify the expression.