Get the previous month of last-non blank

[Anonymous]

Hello everyone! I need your help with getting the value of the previous month of the last nonblank.

I already got the last non-blank value but I'm struggling with getting the previous month.

Year	Month	Accounts	Contacts	Service
2018	2018 - 03
2018	2018 - 04
2018	2018 - 05
2018	2018 - 06
2018	2018 - 07
2018	2018 - 08
2018	2018 - 09
2018	2018 - 10			2
2018	2018 - 11	4	2
2018	2018 - 12	1	3
2019	2019 - 01
2019	2019 - 02
2019	2019 - 03

Current Accounts: 1
Prev Month Account: 4
Current Contacts 3
Prev Month Contact: 2
Current Service: 2

Prev Month Service: 0

[v-juanli-msft]

Hi @Anonymous 

Is this problem sloved?

If not, please let me know.

Finally you want "Current Accounts" and "Prev Month Account" for "Accounts"," Contacts" and "Service" to show on cards visual,right?

Best Regards

Maggie

[PattemManohar]

@Anonymous  Please have a look into the below post that is similar and might help...

https://community.powerbi.com/t5/Desktop/Filling-balance-for-missing-days/m-p/647472#M310402