Date Dimension

[AleCruc94]

Hi everyone,

i am trying to create a table with two columns and just one row:  i want a row where i have the status of revenues at the maximum date

 in my case  the filed is 'status' and the record 'Validated' so the output should be :

data , status 

maximum(Date) , validated

but  when i try to use in the table the Dimension  =Date(Max(DataPL))  it does not work,.

Any suggestions?

Thanks in advanced

Alessandra

[AleCruc94]

thanks this works!

[Kushal_Chawda · Accepted solution]

see the attached.

If works please mark the answer as correct

[tresesco]

Please close the thread by marking and/liking the correct answer. Also, if you are trying the expression with aggr() suggested above, I would suggest to try the one I suggested without aggr(), because that is more efficient  in terms of performance.