Welcome to the forum – great to have you here!
In general, you will get the best response and most specific solutions if you provide your PBIX file along with your question. In this case, I just used a simple sample dataset, linked to the Extended Date Table. I then created a what-if parameter for your percentage applied, and then wrote the following two measures:
Average Daily Price per Month =
CALCULATE(
AVERAGE( Sales[Unit Price] ),
ALLEXCEPT(
Dates,
Dates[Month & Year]
)
)
Avg w % Applied =
[Average Daily Price per Month] *
DIVIDE( 'Percentage Applied'[Percentage Applied Value], 100 )
Here’s what it looks like all put together:
I hope this is helpful. Full solution file attached below.
- Brian