Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

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's avatar
    Anonymous
    Not applicable
    7 years ago

    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.