Forum Discussion
Assistance required - Power Pivot Dax formula
Hi, Please assist in building the DAX formula to arrive the Expense ratio in relation to Sales for different customers / stores/ period. The details are attached in the excel sheet.
Before starting with DAX measures proper data model shall be built. That is time consuming project, you may find some details here Easy Profit and Loss and account scheme reports DAX PowerBI Pivot (thebiccountant.com)
Easy Profit & Loss (and other account) statements in PowerBI and Excel - Part2 – The BIccountant