Display Current Month over Month Change in a card

[aashton]

Hello,

I am able to compute a Month over Month change as seen below.  I'd like to dispaly the current months Month Over Month change in a card, so today it would show -95.83 for August.  I've tried creating 

Current Month = IF(MONTH(Leads[Entry Date])=MONTH(TODAY()), 1, 0) and filtering on this, but it doesn't work:

[v-zhangti]

Hi, @aashton 

You can try the following methods.

Measure = CALCULATE([Month Over Month Percentage],FILTER(ALL(Leads),[Entry Date].[MonthNo]=MONTH(TODAY())))

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[aashton]

@v-zhangti  Yes, that is exactly what I want.  But I am still getting 0%:  

[amitchandak]

@aashton , if nothing is selected in date table (use date tbale)

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))

Ignore the selected value of date table

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

Based on selected dates

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]))
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]))

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

Try like

https://medium.com/chandakamit/cheat-sheet-power-bi-time-intelligence-formulas-using-today-654f26e27...

[aashton]

@amitchandak   Thank you so much for your help....Not sure I understand everything that is going on there.  What I did, created the measure:  

This Month Today Filter =

var _min = EOMONTH(TODAY(), -1)+1

var _max = EOMONTH(TODAY(), 0)

return IF(MAX(Leads[Entry Date]) >=_min && MAX(Leads[Entry Date]) <= _max, 1, 0)

And was going to use this as the filter on the card, but was getting the wrong results.  It did let me add to filter to a multi-row card, and I got the correct results.  Still trying to figure out a card....