Contributor

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

2 REPLIES 2
Community Boss

Re: Time where a value is max

@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

Contributor

Re: Time where a value is max

Thank you, Rob.

Perfectly worked for me.

Cheers.