Multiply a measure by fiscal month

DAX DAX Calculations
1

Hello,

I would like to create a simple YTD budgeted amount to compare actual revenue to, on a monthly basis.
I’ve created a monthly measure (total annual budgeted revenue/12) [Monthly Budgeted Revenue] , and would then like to multiply this by the fiscal month as per my date table.

Can anyone please help with this please? Thanks!

2

Hello @Juju,

Thank You for posting your query onto the Forum.

Could you please upload the PBIX file for the reference alongwith the mock-up of the results that you’re trying to achieve here? So that members of the forum can assist you in a better and efficient manner.

Also on our education portal there is a specfic section of course available onto this topic pertaining to “Budgeting and Forecasting”. I’m providing a link below of that course for the reference purpose.

Thanks and Warm Regards,
Harsh

1 Like
3

Hi @juju, did the response provided by @Harsh help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query. Thanks!

1 Like
4

Hi @juju, we’ve noticed that no response has been received from you since the 12th of March. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.

1 Like