Sort or order by either Desc or Asc in DAX formula

[Nagesh20]

Hi All,

I would like to insert sort option (anything - Ascending or Descending) in dax formula in the below. Please advice

Net = SUM(Table3[Payble])+SUM(Table3[Receivable])

[MNedix · Accepted solution]

Hi,

RANK or RANKX will do the job depending on what you want - https://learn.microsoft.com/en-us/dax/rank-function-dax