Forum Discussion

RachC's avatar
RachC
Helper I
9 years ago

Contain value in Slicer

Buddies ,I want to design a filter that could  choose  this week this month this year I make a DAX function        thisDate = IF(WEEKNUM([_DATE]) = WEEKNUM(NOW()),"THIS WEEK", IF(MONTH([_DATE...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi RachC,

 

You can use below formula to check the date range:

 

Measure:
CheckDate = 
var checkYear=YEAR(MAX('Table'[Date]))=YEAR(NOW())
var checkMonth=MONTH(MAX('Table'[Date]))=MONTH(NOW())
var checkWeek=WEEKNUM(MAX('Table'[Date]),1)=WEEKNUM(NOW(),1)
return
IF(checkYear,if(checkWeek,"This Week",if(checkMonth,"This Month","This Year")),"Different Year")

 

 

 

In addition, you can also take a look at following formula which check date based on slicer:

 

Measures:
Selected = if(HASONEVALUE('Table'[Date]),VALUES('Table'[Date]),BLANK())

CheckDate(Slicer) = 
var checkYear=YEAR([Selected])=YEAR(NOW())
var checkMonth=MONTH([Selected])=MONTH(NOW())
var checkWeek=WEEKNUM([Selected],1)=WEEKNUM(NOW(),1)
return
IF(checkYear,if(checkWeek,"This Week",if(checkMonth,"This Month","This Year")),"Different Year")

 

 

Regards,

Xiaoxin Sheng

  • RachC's avatar
    RachC
    Helper I
    9 years ago

    um..it can't resolve my problem.

    I thought I explain accurately,the filter need latest 7 day,14 day.

    If you set the label in column like this week or this latest14day that you can't contain the other inforamation unless you choose both.But it's not my goal.

    I found the M code but I didn't implement with this blog.If it works well I will share in this post!