Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Dax Query for Avg

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.