Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
Would you be able to share a sample to show the issue?
HI Marta,
What is the output of the 'Fecha_max_exportacion_1'? Is this a field, variable or an attribute of a field?
You can try $(Fecha_max_exportacion_1).
Jordy
Climber