Support Formation DAX

Résumé des fonctions

Relations dans le modèle

Filtres

Résultat :

DAX KEEPFILTERS function
DAX KEEPFILTERS function

Exemples complets

Différence avec période précédente

Sales PM :=
VAR CurrentYearMonth = SELECTEDVALUE ( 'Date'[Year Month Number] )
VAR PreviousYearMonth =
    CALCULATE (
        MAX ( 'Date'[Year Month Number] ),
        ALLSELECTED ( 'Date' ),
        KEEPFILTERS ( 'Date'[Year Month Number] < CurrentYearMonth )
    )
VAR Result =
    CALCULATE (
        [Sales Amount],
        'Date'[Year Month Number] = PreviousYearMonth,
        REMOVEFILTERS ( 'Date' )
    )
RETURN
    Result

Et au final :

Sales Diff PM :=
VAR SalesCurrentMonth = [Sales Amount]
VAR SalesPreviousMonth = [Sales PM]
VAR Result =
    DIVIDE (
        SalesCurrentMonth - SalesPreviousMonth,
        ( NOT ISBLANK ( SalesCurrentMonth ) ) * ( NOT ISBLANK ( SalesPreviousMonth ) )
    )
RETURN
    Result
% Sales Diff PM =
DIVIDE (
    [Sales Diff PM],
    [Sales PM]
)