Calculate month with highest sales

[o59393]

Hi all

How can I return in a dax measure the month whose got the highest volume in any month?

In this case the highest volume is march, therefore the dax should return me March:

I already have calculated the maximum volume for march:

How could I get the march month with dax?

Thanks.

[rsbin]

@o59393 ,

You can try something like this:

MaxMonth = CALCULATE( MAX( Query1[Month 445] ),
                      FILTER( Query1, Query1[Rolling with % produced by plant] = 
                                             [Month Max demand] ))

I have tried my best to interpret your table and column names.  You may have to adjust the syntax if I have not got them correct.

Hope this helps.

Regards,

[o59393]

Hi  @rsbin 

I got this error:

To summarize what each means:

Query1[Period[Month 445]]]: is the column for Month

[Rolling with % produced by plant]: dax measure which basically is the sum of the KO volume column.

Hope that works.

Thanks.

[rsbin]

@o59393 ,

Then please try this:

MaxMonth = CALCULATE( MAX( Query1[Month 445] ),
                      FILTER( Query1, Query1[KO Volume] = [Month Max demand] )) = 

  Regards,