cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ogureisuo Regular Visitor
Regular Visitor

Get the previous month of last-non blank

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.

 

YearMonthAccountsContactsService
20182018 - 03   
20182018 - 04   
20182018 - 05   
20182018 - 06   
20182018 - 07   
20182018 - 08   
20182018 - 09   
20182018 - 10  2
20182018 - 1142 
20182018 - 1213 
20192019 - 01   
20192019 - 02   
20192019 - 03   

 

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

Prev Month Service: 0

2 REPLIES 2
Highlighted
Super User
Super User

Re: Get the previous month of last-non blank

@ogureisuo  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



Did I answer your question? Mark my post as a solution !

Proud to be a Datanaut !





Community Support Team
Community Support Team

Re: Get the previous month of last-non blank

Hi @ogureisuo 

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