Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Issue with refund calculation per month

Hi all, I'm pretty new to power bi. I need to calculate some refunds for my boss, but can't get the right calculation. I have a table (Sheet1) with billing type (credit(refund) and invoice(turnover...
smpa01's avatar
smpa01
Icon for Community Champion rankCommunity Champion
4 years ago

Anonymous  please try

 

Refund% =
VAR _credit =
    CALCULATE (
        SUM ( Sheet1[EUR sales] ),
        FILTER ( VALUES ( Sheet1[Billing type] ), Sheet1[Billing type] = "Credit Memo" )
    )
VAR _invoice =
    CALCULATE (
        SUM ( Sheet1[EUR sales] ),
        ALL ( Sheet1[Billing month] ),
        Sheet1[Billing type] IN { "Invoice" }
    )
RETURN
    DIVIDE ( _credit, _invoice )

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Unfortunatly I didn't receive a different result (Refund %2 = your formula)