Forum Discussion

kasife's avatar
kasife
Helper V
3 years ago

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 resolve?

I try to change the orderby using the Assinatura "PJ " column but I get an error

 

 

_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]),
        ORDERBY(Ultimo_Reaal[Nome do Projeto Original],ASC))))

 

 

 

 

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    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

  • kasife's avatar
    kasife
    Helper V
    3 years ago

    amitchandak 

    Now my dates are gone. In the previous function it was bringing it correctly, but it was doing the function based on the order of the projects only and I wanted it to do it based on the order of the Date PJ too.