set analysis max export date

martapardo — Thu, 06 Jun 2019 09:57:22 GMT

Hi, I have a sheet which will have 3 tables and two of them should take data belonging to the maximum export date and the other the other one all the data not filtre , I was trying in each measure do set analysis filtering by this condition, since I have the max(export date) as a variable saved previously but it is not working.

The code is :

=aggr(count(DISTINCT {<curso_PORCENTAJE = {'1'}, curso_Fecha_exportacion = {'Fecha_max_exportacion_1'}>} curso_Usuario), curso_curso_nombre)

The important notation is:

curso_fecha_exportacion = export date of each raw in my table

Fecha_max_exportacion_1 = maximum export date of all table(I have already compute in the data model)

and before it was like that , it was working perfectly:

=aggr(count(DISTINCT {<curso_PORCENTAJE = {'1'}>} curso_Usuario), curso_curso_nombre)

I have trying xtracting the month since the only thing that it changes is the month not the year but still not working I have try also setting Date(export_date) because I though it could be the format but still not working...

topic set analysis max export date in App Development

set analysis max export date