Forum Discussion
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 measure for sales volume which i am using card to display. the line items of Income Statement like Sales, Cost of Sale, Operating Expense, Depreciation and Finance Cost all this line item will be divided by sale volumes. Can you please help in providing the solution, please
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
9 Replies
Hi aj1973,
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
Hi mohammedksa
Here you go
your mistake was here
you didn't put the variable you created for the denominator.
when creating VAR have the habbit to add "_" in order not mix between VAR and measures
pls provide some sample data and expected output
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
