Forum Discussion

mohammedksa's avatar
mohammedksa
Frequent Visitor
2 years ago
Solved

Divide Measure - Numerator from One Table and Denominator Table from other Table

I am preparing Incomce statement, The GL amount is calculate and bourght from GL Ledger amount which is my denominator and the numerator is the total sales which is in another Sales Table, I have mea...
Need Help
  • mohammedksa's avatar
    mohammedksa
    2 years ago

    Dear Mr. Aj1973,

    Finally i got the solution, Thanks you once again, Appreciate if you can share any lilnk to learn abour variable and Dax measures

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
2 years ago

mohammedksa 

pls provide some sample data and expected output

mohammedksa's avatar
mohammedksa
Frequent Visitor
2 years ago

Hi Ryan, 

I am new to Power bi beginer stage but still manage to create the above income statement, I have sale volume in one table and Income statement in other i want to divide my Sales volume with the Line item and then with Sub line item to ascertain the per unit value, In addition i want to remove the negative sign, Thanking you in advance for your help

 

Please find enclose below link for my file 

https://portals.wetransfer.com/reviews/19866d0a-e442-48f7-b87a-ab4593f0b9b0