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 between measures without to build a specific calculate measures for every year, I just want to have % differences that calculate automatically that differences, for Net Sales, for Net Sales Avg and Qty Distribution (3 measures) Its seems easy but i dont find the right way to do it Best regards

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

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.

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

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.

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..

% Difference between Measures | Microsoft Fabric Community

11 Replies

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
  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
  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
    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.

Forum Discussion

% Difference between Measures

11 Replies

Related content

Cumulative Difference from Another measure

Different schema into different destination

Toggle between different measures

Waterfall with different measures and different colours

Different measures in Matrix visual