cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
nanutum Frequent Visitor
Frequent Visitor

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 table

BI001.PNG

 

My Problem

in Dashbroad my Sale summary used this Code 

Sell Out MTD = CALCULATE(SUM('Tran'[Trans Amount]),DATESMTD(Calendar[Date]))

i must chose No#month for show data in current month 

 

BI002.PNG

 

i want Sales summary show Current month by Now in Calendar table .

i try Sell Out MTD = CALCULATE(SUM('Tran'[Trans Amount]),DATESMTD(Calendar[Now])) is not working

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: How to Used DATESMTD with NOW

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


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


2 REPLIES 2
Super User
Super User

Re: How to Used DATESMTD with NOW

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


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


nanutum Frequent Visitor
Frequent Visitor

Re: How to Used DATESMTD with NOW

Thank You sir You save my Day