Exclude a particular month in average sales

DAX DAX Calculations
1

Hi Team, there is one query regarding average sales but excluding December month as sales is always in December due to festive season. for example I am currently in Feb month and i want to calculate average sales from Jul- Jun (our fiscal year starts with Jul) but excluding December sales in this average. I want to provide an analysis where i can tell me my manager that for these many customers MTD (Feb) sales is higher than their average sale.

Any link would do. I would take it from there. I have a calendar table and a sales table.

Thanks in advance.
Regards
Harish Rathore

2

Hi @harishrathore. Try just including month <> 12 in your filter (or, alternatively, filtering-out out month = 12).
Greg

3

@Greg - Thanks for your prompt response. I have used NOT( SEARCH( “Dec”, ‘Calendar’[FiscalMonth], 1, 0 ) >= 1 ) and got desired result. Is this method okay in terms of optimization ? Would be happy to hear from you.

Thanks & Regards
Harish Rathore

4

Hi @harishrathore. As long as it works and is easy to understand. I (and I expect other forum members) can’t comment on optimization without seeing your implementation in your PBIX file. In case I’m wrong, looping-in DAX and general overall Power BI optimization experts @AntrikshSharma and @Nick_M.
Greg

1 Like
5

@Greg - Thanks Greg. The above method works very fine for me. Thanks

Regards
Harish Rathore