Forum Discussion

nanutum's avatar
nanutum
Icon for Helper I rankHelper I
9 years ago
Solved

How to Used DATESMTD with NOW

now when chcange month i always Slicer in Report and add on Dashboard for change data    howevery i want dashboard change data follow Report can possbile   i have Calendar Table and i add Now in ...
General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Greg_Deckler's avatar
    Greg_Deckler
    9 years ago

    You may need to adjust this a bit but what about creating a column like this:

     

    IsToday = IF(DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY()))=[Date],1,0)

    Then you can just filter to IsToday=1

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
9 years ago

You may need to adjust this a bit but what about creating a column like this:

 

IsToday = IF(DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY()))=[Date],1,0)

Then you can just filter to IsToday=1

nanutum's avatar
nanutum
Icon for Helper I rankHelper I
9 years ago

Thank You sir You save my Day