Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Measure to get previous month data

I have a query could you pls help me to get this sorted. Have a slicer where it contains month as 22-08, 22-09, 22-10, 22-11, 22-12. Based on the slicer value selection I have to always get previous ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

I have the Calendar table linked with NGRReport table which is been used in the measure.
I tried taking Created month column as slicer value in date format & got the expected results using PREVIOUSMONTH. But one issue is when the slicer is selected as ALL it shows same values in current month, overall report generated & blank in previous month card.
Could you pls help how to sort this.

Always the slicer selection should be as ALL & there are other visuals in the report to show data as Overall. 

 

 

 

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

When you set Created Month to "All" the concept of a previous month no longer applies. Rethink what you are trying to achieve.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Ok got it thanks. 
    The measure which I used to get previous month data doesnt show correct data. Could you pls help me on this.

    Measure used - 

    CALCULATE(COUNT(NGRReport[reportid]), PREVIOUSMONTH(NGRReport[Date]))
    ForNov - 


    Supposed to get 63 in place of 10 here 

    I have Date table as well in model & connected. 
    Slicer created on is date column from NGRReport 

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      3 years ago

      Change your PREVIOUSMONTH  function to use the date from the calendar table.