New Enterprise DNA Initiatives

How to calculate Best Selling Month, Best Selling Week in Power bi?

how to calculate best selling month, best selling week as like worst selling month and worst selling week for the card visual as like following image.

Hi @dipeshkumar30,

I misread you question initially… give this a go

You can change the Date dimension to identify best selling week using the same basic pattern.

Max Month Period =
VAR vTable = VALUES( Dates[Month & Year] )
VAR MaxSales = MAXX( vTable, [Total Sales] )
VAR KeepMax = FILTER( vTable, [Total Sales] = MaxSales )
VAR CombineMax = IF( MaxSales >0, CONCATENATEX( KeepMax, [Month & Year], ", "))


I hope this is helpful.

Hi @dipeshkumar30, did the response provided by @Melissa help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark the thread as solved. Thanks!

A response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box. Thanks!