Forum Discussion
Sort column using offset function
Hi Guys, I created this function and it's working fine, but it's bringing the result based on the order of the projects and I would like the result to be sorted by the "Data PJ" column. How could I ...
kasife , It need to part of the relation
_OFFSET data PJ =
VAR Datapj = MAX(Ultimo_Reaal[Assinatura PJ])
RETURN
IF(Datapj<>BLANK(),
CALCULATE(
MAX(Ultimo_Reaal[Assinatura PJ]),
OFFSET(+1,
ALLSELECTED(Ultimo_Reaal[Nome do Projeto Original],Ultimo_Reaal[Data PJ] ),
ORDERBY(Ultimo_Reaal[Data PJ],ASC))))
April 2023 onward, measures can be used outside the relation/table in order by