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

[kai25]

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

[lbendlin]

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

[kai25]

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.

[lbendlin]

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-...

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/1447...

[kai25]

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

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