topic Re: Average of Monthly sale values as per user input of start and end month in DAX Commands and Tips

Average of Monthly sale values as per user input of start and end month

kai25 — Mon, 03 Jun 2024 06:59:48 GMT

I have a source data with monthly sale value for different categories of products, in my pbi report i show all values filtered by year, i want to create a column that is the average of sales value, the start month and end month should be a user input.

the data looks something like this:

Product Category. Jan Feb Mar..........Dec

A. 2. 34. 5. 3

B. 36. 51. 4. 21

P. 22. 39. 41. 10

Re: Average of Monthly sale values as per user input of start and end month

lbendlin — Mon, 03 Jun 2024 14:17:08 GMT

that should be possible with the standard visuals, no coding required. What have you tried and where are you stuck?

Re: Average of Monthly sale values as per user input of start and end month

kai25 — Wed, 05 Jun 2024 08:37:20 GMT

the standard visuals gives me the average of all months, what i want is the user should be able to get the average of the desired months, that start and end should be a user input maybe a slicer, and i should get the average of that, eg, user input is start month- Aug, end month- Nov and the output shour be average of Aug sept oct and nov sales.

Re: Average of Monthly sale values as per user input of start and end month

lbendlin — Wed, 05 Jun 2024 19:57:42 GMT

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Re: Average of Monthly sale values as per user input of start and end month

kai25 — Thu, 06 Jun 2024 04:21:36 GMT

https://docs.google.com/spreadsheets/d/1nHl88a0jURhK9H_iXLczpErvbcp7SKne7ow3eBaAJY4/edit?usp=drivesdk

I here is a sample data.

the outcome i am looking for is that in the pbi report view there should me a slicer to add the start month and another for end month and the measure should calculate average sales for that range of months