Gallery
Support Formation DAX
Share
Explore
Fonctions d'agrégation

icon picker
RANKX

VAR BrandsAndSales =
ADDCOLUMNS (
VALUES ( 'Product'[Brand] ),
"@Amt", [Sales Amount]
)
RETURN
ADDCOLUMNS (
BrandsAndSales,
"Rank",
RANKX (
BrandsAndSales,
[@Amt]
)
)
Rang de l’année précédente :
RankPreviousYear =
VAR nPreviousYear = FORMAT(MAX('Date'[Date]),"YYYY")-1
RETURN
RANKX(
ALL('Product Category'),
CALCULATE(
Sales[SalesAmount],
OrderDate[Year]=nPreviousYear
)
)
image.png
Share
 
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.