Forum Discussion

MIkeMak's avatar
MIkeMak
Regular Visitor
9 years ago
Solved

Incremental percent

  How do I calculate the column "incremental percent" in Power BI for example  for column D1 the formula is =+C1/B1-1 , the  formula for column D2  is =+SUM(C1:C2)/SUM(B1:B2)-1 and the formula for ...
  • mattbrice's avatar
    mattbrice
    9 years ago

     

     

    Actually, after thinking about it, I think the VAR will be out of scope for the FILTER, so need to change this to:

     

     

    measure =
CALCULATE (
    DIVIDE ( SUM ( Table[C] ), SUM ( Table[B] ) ) - 1,
    FILTER (
        ALL ( Calendar ),
        Calendar[MonthNumber] <= MAX ( Calendar[MonthNumber] )
    )
)

     

  • v-huizhn-msft's avatar
    v-huizhn-msft
    9 years ago

    Hi MIkeMak,

    Please try the measure like mattbrice posted. Set the measure data type as percentage.




    Then create a table visual, select the month, sales last year sales, current year sales and measure as value, you will get expected result.



    Best Regards,
    Angelia 

v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi MIkeMak,

Please try the measure like mattbrice posted. Set the measure data type as percentage.




Then create a table visual, select the month, sales last year sales, current year sales and measure as value, you will get expected result.



Best Regards,
Angelia 

MIkeMak's avatar
MIkeMak
Regular Visitor
9 years ago

Thank you!  v-huizhn-msft and  mattbrice for the solutions , best regards