Help with Measures

[fbostan1]

Hello,

I have 2 pages I am working with, I need the percentage of month +7 from GIACT Issued Wfall to display in Trend- Issued for the matrix I have showing the percentages for each month, and for November, I need it to show for Month +6 because thats how many month it aged and so on.

The three colors are from column called COLOR_CODE which is in table Submitted_Policies.

I know I have to write some measures, thats where I am stuck. Any help would be apprecaited. 

This is the two pages I have:

This is from GIACT Issued Wfall Page:

This is from Trend-Issued Page:

[v-yalanwu-msft]

Hi, @fbostan1 ,

Is your problem solved? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yalanwu-msft]

Hi, @fbostan1 ,

Sorry I'm not really following your logic, 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,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[fbostan1]

This is exactly the same but in excel. it's easy in excel to get the results.