Calculating GWP off Expiration Date

[M-N-C]

Hey Everyone, 

I'm trying to find the sum of money from accounts that expire in X month. I want it took look at the column and row filters in the matrix to check for accounts that expire that month year and then sum up the amount of money coming from those expiring accounts. 

Is there a measure that is able to do this or will I need to create an Expiration Table?

Thanks!

[M-N-C · Accepted solution]

I ended up just making a seperate report that did not use my normal Date filter. Ended up filtering by the Expiration date so that all my other filters could interact fairly normal.

[v-xuding-msft]

Hi @M-N-C ,

Have you implemented it? If yes, please share your solution and accept the helpful answer. More people will benefit from the thread. If you still need help, please share some sample data and expected results.

[v-xuding-msft]

Hi @M-N-C ,

Can you please share some sample data and expected results? Just based on description, we may not get you.

Please see this post regarding How to Get Your Question Answered Quickly: 

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490