Time where a value is max

Hi, guys

 

What I am trying to acheive is pretty simple as in the attached file.

I would like to identify a month where "sales" is maxium among "TIME" dimension(Jan 2018 to Dec 2018)

Any pointers?

Thanks in advance

 

Greg

Best Answer

  • @gregoryTan 

     

    On the Sales line, set the summary to MAX. 2019-01-24_12-51-48.png

     

    Create another module with the only List being Time, call this Time Filters with the following line items.

     

    2019-01-24_12-52-11.png

    In the orginal module, update the Max Sales line item to be a Boolean and add this formula: Data = Data[LOOKUP: Time Filter.FY Year]

    2019-01-24_12-52-53.png

     

    Hope this helps,

     

    Rob

Answers