Forum Discussion
Need Help to Convent Excel Formula into Power Bi
Hi Everyone. I have excel file Link: https://1drv.ms/x/s!Ag7FsQb8nMXMhAjAKTxdJv0HhfEK?e=W93LVi which I have to convent into the bi file. Excel Version Formula: IF(J7>=AF7,((AF7*B7)-(J7*B7))*SUM...
Without the Power BI file it is hard to help. Did you include *-1 in your Power BI formula? I don't see it.
Anonymous *-1 for just negative Value. , All calculation is possible from excel file
Anonymous wrote:Without the Power BI file it is hard to help. Did you include *-1 in your Power BI formula? I don't see it.