cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Anonymous
Not applicable

## Weekly Sales as Percentage of Corresponding Month Budget Total

Hello Everyone,

I need your expert advise. What would be the DAX formula to calculate weekly sales (cumulative) percentage of the corresponding month budget?

I was able to use DATESMTD function to calculate cumulative weekly sales by month (see below). I have no idea how to calculate what percentage of monthly budget sales those cumulative numbers are. Please refer to the picture below if my explanation is not clear.

Alex

1 ACCEPTED SOLUTION
Super User

Hi,

Try this

=[2017 DatesMTD]/CALCULATE(SUM(Date[Budget Sales]),ALL(Calender[Week]))

Hope this helps.

Regards,
Ashish Mathur
http://www.ashishmathur.com
2 REPLIES 2
Super User

Hi,

Try this

=[2017 DatesMTD]/CALCULATE(SUM(Date[Budget Sales]),ALL(Calender[Week]))

Hope this helps.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Anonymous
Not applicable

Thank you, Ashish_Mathur,

I was able to figure this out on my own and planned to post the solution. ALL(Calendar[Week]) was a missing piece in this puzzle.

In my case the formula happened to be:

=[2017 DatesMTD] / CALCULATE(SUM(Budget[Amount]), ALL(Calendar[Week]))

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

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

#### Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors