Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

% Difference between Measures

Hi guys,   im trying to calculate simple way difference between tow rates or even more but I dont find the proper way to do it. Here is the thing:     Id like to calculate differences betw...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Sorry I am not quite following what you need to do.

 

Could you provide a screenshot of what it would look like in Excel for excample?

 

Thank you

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Sure.

     

     

    I need this but I want to create a formul that calculate % differences automatically

     

    Net sales, Net Sales Avg and Qty Clientes are sum's and distinct count without to be a specific year.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    anybody can help me? I want to have a formul that generate automatically filter without to put the year

     

    something like this

     

    % Differences net sales= calculate(sum(netsales);filter(dates; year=year automatically))

     

    Now I must créate net sales 2018, net sales 2019 also build % differences net sales 2018, % differences net sales 2019 

    • dax's avatar
      dax
      Community Support
      6 years ago

      Hi edumen, 

      I am not clear about your requirement, did you mean you want to get difference between current year and previous year ? Or other year? If possible, could you please inform me the formula and expected output, then I will help you more correctly.

      Please do mask sensitive data before uploading.

      Thanks for your understanding and support.
      Best Regards,
      Zoe Zhi

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Yes, that's correct, I want to know how can I create % differences between sales per each year.

         

        I dont know how can I made it, just I know putting each year, look this:

         

        Net Sales Current = CALCULATE(SUM([Net Sales]);FILTER('Detalles Fechas';'Detalles Fechas'[Año Fiscal]="FY 2019"))

         

        Net Sales LY = CALCULATE(SUM([Net Sales]);FILTER('Detalles Fechas';'Detalles Fechas'[Año Fiscal]="FY 2018"))
         
        % Dif Net = IFERROR(([Net Sales Current]-[Net Sales LY])/[Net Sales LY];BLANK())
         
        I dont want to put the year in each formul, I would like to get something automatically if it'd be possible..