Obtaining last month graphic while using a date slicer
Hi everyone, I would like to show the selected month and previous month data, allowing for the user to select a month via a Month Year slicer. I have a User table, and a Date table. My Date table has month offset. I'm not sure what I need to do to my measures, for it to still be able to take into consideration the selected month, but show me the values of the selected month -1. When I try to do that in my measure, shows up blank (the 3rd bar from the top on the "Previous Month" funnel). I can't tell it to ignore the Month Year filter, because I need it in the calculation, to subtract by month offset -1. Any thoughts? This is an example of how I tried to filter for the previous month within my measure. # Accredited Users (time based -1 month) = CALCULATE(DISTINCTCOUNT(Users[User Id]), FILTER(Users, Users[Accredited Status]="ACCREDITED" ), FILTER(ALLSELECTED('Date Table'), 'Date Table'[Month Offset]=-1), USERELATIONSHIP(Users[Date],'Date Table'[Date])) But since I have the Date slicer on, it's not showing any data outside of the date slicer range.
