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.
Any help would be appreciated it.