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.

Rémi's avatar
Rémi
Icon for Resolver III rankResolver III
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.

  • Enrico's avatar
    Enrico
    Frequent Visitor
    10 years ago

    We are here in the service forum, not dekstop.

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    Hello,

     

    The filter is available as a date format only. I am unable to select the date difference as < 90 days.

     

    Can you help me?

     

    Thank you

    J

    • 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)

  • djnww's avatar
    djnww
    Icon for Impactful Individual rankImpactful Individual
    10 years ago

    Thanks for the great tip, Rémi

     

    I'm kicking myself for not thinking of this workaround solution.

     

    - Daniel

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    Hello,

     

    It is not clear to me how would I use the filter.

     

    I was able to create the new measure.