Weekly Sales as Percentage of Corresponding Month Budget Total

[Anonymous]

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.

Thank you all in advance.

Alex

[Ashish_Mathur · Accepted solution]

Hi,

Try this

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

Hope this helps.

[Anonymous]

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]))