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

DAX DAX Calculations
1

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.
image

2

Hi @dipeshkumar30,

I misread you question initially… give this a go

image
image639×704 48.9 KB

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], ", "))
RETURN

CombineMax

I hope this is helpful.

3

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!

4

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!