Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

% Variation Over Years - DAX synthax issues

Hi the community,    I'm making progress with PBI, specially in YOY analysis, but i'm still stuck with beginner issues...    So here is my problem :    I was looking to calculate variation quan...
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    Pretty sure you want:

     

    % Variation CY LY =
VAR _currentyear = SUM('Scrap Projection'[Order Quantity])
VAR _LastYear = [Quantity LY]
RETURN
(_currentyear - _LastYear) / _currentyear
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

Pretty sure you want:

 

% Variation CY LY =
VAR _currentyear = SUM('Scrap Projection'[Order Quantity])
VAR _LastYear = [Quantity LY]
RETURN
(_currentyear - _LastYear) / _currentyear
Anonymous's avatar
Anonymous
Not applicable
6 years ago

thank you so much Greg for your help 🙂 

Wish you the best !