Forum Discussion

Buyer_JC78's avatar
Buyer_JC78
Regular Visitor
2 years ago
Solved

Formula not working - Power BI Desktop

I need help with a Power BI formula. I'm trying to add a column which calculates a negative value from column A (Invoice Value) if column B states "credit note" or if column B states "invoice" then ...
Need Help
  • rajendraongole1's avatar
    rajendraongole1
    2 years ago

    Hi Buyer_JC78 -Can you try below calclulated column to reflects the negative values for "CREDIT NOTE" and positive values for "INVOICE".

     

    NewColumn = IF(TRIM(U5PURCHASINGGRID[INVType]) = "CREDIT NOTE", U5PURCHASINGGRID[INVOICE VALUE (LINE)] * -1, U5PURCHASINGGRID[INVOICE VALUE (LINE)])

     

    Hope it works

     

    Did I answer your question? Mark my post as a solution! This will help others on the forum!
    Appreciate your Kudos!!

rajendraongole1's avatar
rajendraongole1
Super User
2 years ago

Hi Buyer_JC78 -Can you try below calclulated column to reflects the negative values for "CREDIT NOTE" and positive values for "INVOICE".

 

NewColumn = IF(TRIM(U5PURCHASINGGRID[INVType]) = "CREDIT NOTE", U5PURCHASINGGRID[INVOICE VALUE (LINE)] * -1, U5PURCHASINGGRID[INVOICE VALUE (LINE)])

 

Hope it works

 

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!