Last value of a dimension

[TomBond77]

Hi experts

We need the last value of a dimension "Category", this one is on the last snapshot "YM", Year Month.

Any ideas how to realize it?

[TomBond77]

only without data, is this possible?

[theoat]

Complicated to testing

[theoat]

It is a KPI

[TomBond77]

Later on i will have to include it into a KPI. Here we only see the variable....

[theoat]

Okay i think i have the answer, can you try this ?
{<YM={"$(=Max({1}YM))"}>}Category

Kind regards,
Théo ATRAGIE.

[TomBond77]

Thanks, but still not working:

Variable: 

[Anil_Babu_Samineni]

@TomBond77 Perhaps this?

firstsortedvalue (Category, -YM, 1)

[TomBond77]

Thank you, that was nearly the solution 🙂

How do I implement that logic in a KPI? The following code exists, only need to reflect the above situation....thanks for any help.

sum(
{<[YearMonth]={"$(='>=' & Monthstart(Addmonths(Max(YearMonth),-11)) & '<=' & MonthEnd(Max(YearMonth)))"}>}
Joiner)

[theoat]

This function is avaible in KPI. You need to use this in KPI no ?
If it is in a table, i am looking for resolve this.

Kind regards,
Théo ATRAGIE.

[Anil_Babu_Samineni]

@TomBond77 If i understand you want to pass the value from logic in tabular to KPI in analysis? Perhaps this?

sum(
{<[YearMonth]={"$(='>=' & Monthstart(Addmonths(Max(YearMonth),-11)) & '<=' & MonthEnd(Max(YearMonth)))"}, [Event Reason]={"$(Chr(39) & =firstsortedvalue (Category, -YM, 1) & Chr(39))"}>}
Joiner)