Forum Discussion

parry2k's avatar
parry2k
Icon for Super User rankSuper User
10 years ago
Solved

How to show data in dashboard for current month

Hello,   I created a dashboard to display sales by month. I have scheduled refresh for the data source but I want my dashboard to show sales by month for last 3 months.    What I need to do i...
Need Help
  • Rémi's avatar
    Rémi
    10 years ago

    Hi,

     

    You have to create an intermediate measure :

    Date difference = NOW() - MAX( [Date] )

    Then you put a filter :

    Date difference < 90

    And you will have your data of the last three months.

tgsteine's avatar
tgsteine
Regular Visitor
10 years ago

You got any answer to this? I have the same question.

vsaveliev's avatar
vsaveliev
New Member
9 years ago

It's possible to use DATEDIFF function:

 

Date difference = DATEDIFF(MAX(Mytable[Date]);TODAY();DAY)