Percentage of monthly totals in Power BI

[Stephanie-curno]

I am trying to make a Power BI report with a matrix that shows monthly and weekly revenue totals for the year. The month names and week numbers are the rows whereas the columns are "revenue measure", and "percent of $20,000". I currently want to add a column that shows weekly revenue as a percent of monthly revenue where each month would show as being 100% and the weeks in the month would make up that total. If someone could please let me know what measure I could add to make this possible, it would be highly appreciated! Thank you!

[v-jingzhan-msft · Accepted solution]

Hi @Stephanie-curno 

To create a measure that shows weekly revenue as a percentage of the monthly revenue, you can follow these steps:

1. Create a measure for monthly revenue:

Monthly Revenue = CALCULATE([revenue measure], ALLEXCEPT(YourTable, YourTable[MonthName]))

Replace 'YourTable' with the actual name of your table and 'MonthName' with the column that contains the month names.

2. Create a measure for weekly revenue as a percentage of monthly revenue: 

Weekly Revenue % of Monthly = DIVIDE([revenue measure], [Monthly Revenue], 0)

3. Format the measure as a percentage. Then add it to your matrix visual. 

If you encounter any issues or have further questions, feel free to ask for more assistance. 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!