Help with getting the maxvalue for specific dimensions and dates

Question

Hello, this is what i need..I need the lastValue of the "Estado" Column...it will the max value of the column "Año Inscripcion"&nbsp;&nbsp;&nbsp;&nbsp;I have the data at this dimension level[Documento, Departamento, Nombre de Materia]&nbsp;I want to get the "Estado" columnAnd i need only for the latest "Año Inscripcion"&nbsp;So i did this, i created a calculated column:&nbsp;&nbsp;&nbsp;Resultado Ultima Cursada = &nbsp; VAR Current_Date = TablaGeneral[Año Inscripción]&nbsp; VAR Previous_Date =&nbsp; &nbsp; &nbsp; CALCULATE (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MAX ( TablaGeneral[Año Inscripción] ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; TablaGeneral[Año Inscripción] &lt;= Current_Date,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ALLEXCEPT ( TablaGeneral,&nbsp; &nbsp; &nbsp; &nbsp; TablaGeneral[Documento],&nbsp; &nbsp; &nbsp; &nbsp; TablaGeneral[Nombre de materia],&nbsp; &nbsp; &nbsp; &nbsp; TablaGeneral[DEPARTAMENTO] )&nbsp; &nbsp; &nbsp; )&nbsp; RETURN&nbsp; &nbsp; &nbsp; CALCULATE (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MAX ( TablaGeneral[Estado ] ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; TablaGeneral[Año Inscripción] = Previous_Date,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ALLEXCEPT ( &nbsp;TablaGeneral,&nbsp; &nbsp; &nbsp; &nbsp; TablaGeneral[Documento ],&nbsp; &nbsp; &nbsp; &nbsp; TablaGeneral[Nombre de materia &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ],&nbsp; &nbsp; &nbsp; &nbsp; TablaGeneral[DEPARTAMENTO] )&nbsp; &nbsp; &nbsp; )&nbsp;&nbsp;Its working, but for some reason is duplicating the values!&nbsp;The ones that I put in red shouldnt be there&nbsp;&nbsp;&nbsp;Can you help me fix that DAX function?Thanks&nbsp;&nbsp;

anonymous · Answer

Hi&nbsp; lrozan&nbsp;,
&nbsp;
You can try the following dax;
Resultado Ultima Cursada =
  VAR Previous_Date =
      CALCULATE (
          MAX ( TablaGeneral[Año Inscripción] ),
          ALLEXCEPT ( TablaGeneral,
        TablaGeneral[Documento],
        TablaGeneral[Nombre de materia],
        TablaGeneral[DEPARTAMENTO] )
      )
  RETURN
      CALCULATE (
          MAX ( TablaGeneral[Estado] ),
          'TablaGeneral'[Año Inscripción]=Previous_Date,
          ALLEXCEPT (  TablaGeneral,
        TablaGeneral[Documento],
        TablaGeneral[Nombre de materia],
        TablaGeneral[DEPARTAMENTO] )
      )
If I have misunderstood your meaning, please provide your desired output and your pbix file without privacy information.
&nbsp;
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Forum Discussion

Help with getting the maxvalue for specific dimensions and dates

1 Reply

Related content

degenerate dimensions

RLS on multiple dimensions

Specific matrix

Parameter table dimensions - summarize

Saving Notebooks to specific folder