Showing data from <Current Month - 2>

[Anonymous]

I'm trying to show the data in a table from 2 months ago using this Measure:

-2 Month Inbound Calls = calculate(SUM('Queue Perf - Total'[Calls]),filter('Queue Perf - Total',month('Queue Perf - Total'[Date])-month(today())=-2))

Took me a bit to realise why it wasn't working, but essentially it's calculating 2(Feb) - 12(Dec) and not calculating <Take 2 months off today's date and show me that data>.

Is there a way to produce that result using DAX?

[v-danhe-msft · Accepted solution]

Hi @Anonymous,

Based on my test, you could refer to below formula:

Sample data:

Create below measure:

Measure = CALCULATE(SUM(Table1[Value]),FILTER('Table1','Table1'[Date]<=TODAY()-60))

Result:

Regards,

Daniel He