Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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))))
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.
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
104 | |
79 | |
68 | |
61 |
User | Count |
---|---|
144 | |
104 | |
103 | |
82 | |
70 |