Hi Everyone,
I'm trying to create a button for selecting last past one month data.
For this i have created a button and added two actions to Set Variable where one variable name is vStartDate and other one is vEndDate for vStartDate i have given a value as =Monthstart(Max({1}[Activity Creation Date]),-1) and for vEndDate =MonthEnd(Max({1}[Activity Creation Date]),-1) this is working fine.
Like changing the vStartDate and vEndDate to past one month dates.
Now, I want on clicking this button it has to apply filter can any one help me with the Select field action The Field i'm using is Activity Creation Date.
Thanks Inadvance.
