How to combine OFFSET and PARTITIONBY within many groups have different records by using DAX

[Tung_Nguyen2402]

Hello everyone,

I face to this problem when I want to lag 1 rank each row for each group, but when I try to use offet I don't know how to implement this. You can see the detail in the picture my solution. Please help me because I'm not familiar with DAX

[wdx223_Daniel · Accepted solution]

why did you use that if function?

and should it be ordered by date?

[Tung_Nguyen2402]

Yes, I want to order by Type and Date too, if same Type then sort by Date. Do you have any idea for order by both columns?