Previous month card

[Anonymous]

I have a SharePoint list that is connected to my PowerBi dashboard. The list contains two columns:

REQUEST TYPE

Call back

Mail

In person

DATE

I want to have a card on my dashboard that lists the count of call back requests for the previous month as well as a card that lists the count of call back requests for the present month to date

Can someone tell me how this is done?

[JorgePinho · Accepted solution]

"count of call back requests for the previous month": CALCULATE(COUNT('TableName'[RequestType]), MONTH(Date) = MONTH(Today()) - 1, 'TableName'[RequestType] = "Call back")

"count of call back requests for the present month to date": CALCULATE(COUNT('TableName'[RequestType]), MONTH(Date) = MONTH(Today()), 'TableName'[RequestType] = "Call back")

[Anonymous]

Jorge,

This solution worked beautifully, thank you so much.  But I have one question:

Is it possible to add something to the formula so that when you click on these cards (ie. Click the card that says 2 Call backs last month) it filters the table to show just the Callbacks from last month?

[amitchandak]

@Anonymous , With help from date table, when you have selected a month on page

example measures

MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))
last MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-1,MONTH)))
last month Sales = CALCULATE(SUM(Sales[Sales Amount]),previousmonth('Date'[Date]))

Based on today not filter

MTD Today =
var _min = eomonth(today(),-1)+1
var _max = today()
return
CALCULATE([Net], FILTER('Date','Date'[Date] >=_min && 'Date'[Date] <= _max))

LMTD Today=
var _min = eomonth(today(),-2)+1
var _max1 = today()
var _max = date(year(_max1),month(_max1)-1, day(_max1))
return
CALCULATE([Net], FILTER('Date','Date'[Date] >=_min && 'Date'[Date] <= _max))

This Month Today =
var _min = eomonth(today(),-1)+1
var _max = eomonth(today(),0)
return CALCULATE([Net], FILTER('Date','Date'[Date] >=_min && 'Date'[Date] <= _max))

Last Month Today =
var _min = eomonth(today(),-2)+1
var _max = eomonth(today(),-1)
return CALCULATE([Net], FILTER('Date','Date'[Date] >=_min && 'Date'[Date] <= _max))

Power BI — Month on Month with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e
https://www.youtube.com/watch?v=6LUBbvcxtKA