Dax Query for Avg

[Anonymous]

Hello Everyone,

I need Dax query, where I can get Avg based on main category rather than subcategory and then divide by total number of months, based on month filter.

Data is simple, I have main product called product 1 and it have several subcategories and its sales by month, so I trying to get an avg sales of product 1 based on month Filter.

E.g. if user select Mar as month and the avg will be calculated total sales on product1 / 9 month (year starts from Jul) but if user select Feb then product 1 / 8 months

In my model I have got two tables main data and months table. Below is the link for excel based data.

[Data]
(https://drive.google.com/open?id=1W0XCMxtIoSmSqWascygJ-FQdcm4ooQ5E)

Any help would be appreciated it.

Thanks.

[amitchandak · Accepted solution]

@Anonymous , Refer if this can help

You need Avg in place of max

https://community.powerbi.com/t5/Desktop/highest-value-by-category/td-p/428758

How all except can help

https://community.powerbi.com/t5/Desktop/Percentage-of-subtotal/td-p/95390

[Anonymous]

Thanks Amit, really appreciate the help.