Last month, prevous month.

[ALEX2011ALfer_]

Hi everyone:)) 

Please help! 

I have this table. 

Date               | percentage 

31/may/2021 | 80% 

31/June/2021  | 70% 

31/may/2022   |  65%

31/ June/ 2022 | 78% 

What I need is a measure that returns the current month value, and the previous month value for current year. 

I will use it in the card visual. So just one value.

I have a big dimdate table with months and years. 

Thanks!! 

[Anonymous]

Hi @ALEX2011ALfer_ ,

You can create a measure as below to get the value on last month...

Last month = CALCULATE(SUM('Table'[percentage]),PREVIOUSMONTH('Table'[Date]))

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards

[amitchandak]

@ALEX2011ALfer_ , With help from date table, these are example for this month vs Last month

examples

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]))
next month Sales = CALCULATE(SUM(Sales[Sales Amount]),nextmonth('Date'[Date]))
this month = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(ENDOFMONTH('Date'[Date])))
last MTD (complete) Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(ENDOFMONTH(dateadd('Date'[Date],-1,MONTH))))
previous month value = CALCULATE(sum('Table'[total hours value]),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

Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date: https://youtu.be/aU2aKbnHuWs&t=145s