Forum Discussion

paulinamaj's avatar
paulinamaj
Frequent Visitor
5 years ago
Solved

last year period

Hi, I created a mensure last year period: Sales LY = IF( 'Sales Ths Units'[Total Sales Units] <> BLANK(), CALCULATE ( [Total Sales Units], SAMEPERIODLASTYEAR ( Timedimension[Da...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    5 years ago

    paulinamaj 

    maybe you can try

    % last period units =if(ISBLANK('Sales Ths Units'[Sales LY]),BLANK(), DIVIDE( 'Sales Ths Units'[Total Sales Units] - 'Sales Ths Units'[Sales LY], 'Sales Ths Units'[Sales LY])
ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
5 years ago

paulinamaj 

maybe you can try

% last period units =if(ISBLANK('Sales Ths Units'[Sales LY]),BLANK(), DIVIDE( 'Sales Ths Units'[Total Sales Units] - 'Sales Ths Units'[Sales LY], 'Sales Ths Units'[Sales LY])