Average Daily Price in a Month for a Specific Product

I am looking for the DAX measure that will calculate the following:

Average of the daily prices of a specific product within a specific month, whereby:
(a) the month is the month the sale was made, e.g. transaction date is 12/23/2019, hence the month is 122019
(b) and then apply a percentage to the answer in (a)

@melaneelee,

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

eDNA forum - Average Daily Price Solution.pbix (371.6 KB)

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

Including all of the above will likely enable a quick solution to your question.