The latest Month

Question

Dear Community,

I have a transaction List and have a Property which Type is Dimension (Month) Text.

I’m looking to create a metric that tells me the latest month on that property.

How can I achieve that?

Thanks in advance :D

icon

Best answer by francois 3 October 2023, 09:14

View original

francois · Accepted Answer

Hi Guillermo,I wrote an article a while back on this topic!You’ll have to turn your text value in a Month or a date though before proceeding - you can do that with those functions - share with us your format if you need more help!

Benoit · Answer

Hi,I wanted to add a remark on this because I often see errors around the modifier behaviors.Here, by“Latest” I know you want to return the most recent Month, and intuitively, you might want to use the “Last” or “Lastnonblank” modifier."Last" versus "Max" modifiersLast is the last item of the list, from top to bottom, so if your list isn't chronologically ordered like ListC in the example below, you might end up with havingunexpected results.Max returns the highest value, no matter the order of the items.Let’s take this list as an example:You can notice that Rome has 2 values but their order is not logical.if you want to return the last Month on all the rows:if you want to return the highestMonth value on all the rows:if you want to return the last Month by a List dimension (Location in this example):if you want to return the highest Month value by a List dimension (Location in this example):Hope it helps.Best,