Assistance required - Power Pivot Dax formula

Question

Hi,&nbsp;Please assist in building the DAX formula to arrive the Expense ratio in relation to Sales for different customers / stores/ period.&nbsp;&nbsp;The details are attached in the excel sheet.

sergeibaklan · Answer

sumesh ek&nbsp;
Before starting with DAX measures proper data model shall be built. That is time consuming project, you may find some details here&nbsp;Easy Profit and Loss and account scheme reports DAX PowerBI Pivot (thebiccountant.com)
Easy Profit &amp; Loss (and other account) statements in PowerBI and Excel - Part2 – The BIccountant

Forum Discussion

Assistance required - Power Pivot Dax formula

1 Reply

Resources