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.

imanzi's avatar
imanzi
New Member
9 years ago

The way I set it up required a few dimensions:

 

Today = TODAY()

StartOfMonth = TODAY() - DAY('MyTable'[Today]) + 1

CurrentMonth = IF('MyTable'[Date] >='MyTable'[StartOfMonth] && 'MyTable'[Date] <= 'MyTable'[Today],1,0)

 

Metric Current Month = IF(ISCROSSFILTERED('MyTable' [Month]),SUM('MyDataTable'[Metric]),CALCULATE(SUM('MyDataTable'[Metric]),FILTER('MyTable','MyTable'[CurrentMonth]= 1)))

 

And the Metric Current Month should be giving you this months results.