cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
fbostan1
Frequent Visitor

Help with Measures

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:

fbostan1_0-1656090297763.png

This is from GIACT Issued Wfall Page:

fbostan1_1-1656090369768.png

This is from Trend-Issued Page:

fbostan1_2-1656090430457.png

 

3 REPLIES 3
v-yalanwu-msft
Community Support
Community Support

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
Community Support
Community Support

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
Frequent Visitor

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

fbostan1_0-1656100868747.png

 

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Show episode 9

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 26

New Date - Check it Out!

Mark your calendars and join us on Thursday, October 6 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors