calculated dimension in the front end

[vikasshana]

Hi,

I've the below data

Year Month PeriodID

2024 Jan 202401

2024 Feb 202402

2024 Mar 202403

2024 Dec 202412

2025 Jun 202506

2025 Jul 202507

I'm looking for a calculated dimension in the front end where it has to take Max Year and Max month of that year, expecting below value in calculated dimension in the front end 

Jul 2025

Regards,

V

[savioricardog · Accepted solution]

Hi @vikasshana 
Try this "=MaxString({< PeriodID = {"$(=Max(PeriodID))"} >} TOTAL Month) &' '& MaxString( {< PeriodID = {"$(=Maxstring(PeriodID))"} >} TOTAL Year)" in a dimension column and check if it works (here it works haha)

[vikasshana]

This works perfect..!!! thanks for helping.

[BrunPierre]

You could try this

Date(Date#(Max(Aggr(Only(PeriodID), Year, Month)),'YYYYMM'),'MMM YYYY')