Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Syndicate_Admin
Administrator
Administrator

Percentages by department

Nice day

I hope you can help me, I want to show by department the expense generated month after month against the budget:

ej1.png

In a table (Purchases) I have the following data:

Department

Date of purchase

My

concept

expenditure

In another table (budget) I have budget with these data:

Department

My

Budget

I have related the tables with Purchases (department) - Budget (department) Many to Many.

How can I put the percentage spent month by month?

y

How can I put the percentage spent annually against the annual budget?

Thanks for the advice and help

0 REPLIES 0

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.