https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Formula-for-Finance-KPI/m-p/3677312#M142786 <P>Hi ,</P><P>Can anyone share me the DAX formulas for below Finance KPI Ratio.</P><TABLE><TBODY><TR><TD>GP Margin</TD></TR><TR><TD>EBITDA margin</TD></TR><TR><TD>NP Margin</TD></TR><TR><TD>Current Ratio</TD></TR><TR><TD>Liquidity Ratio</TD></TR><TR><TD>Return on Investment Ratio</TD></TR><TR><TD>Return on Capital Employed Ratio</TD></TR><TR><TD>Earning per Share</TD></TR><TR><TD>Dividend Yield Ratio</TD></TR><TR><TD>Net Profit to Net worth Ratio</TD></TR><TR><TD>Inventory Turnover Ratio</TD></TR></TBODY></TABLE><TABLE><TBODY><TR><TD>Working Capital Turnover Ratio</TD></TR><TR><TD>Fixed Asset Turnover Ratio</TD></TR><TR><TD>Capital Turnover Ratio</TD></TR><TR><TD>Debt Equity Ratio</TD></TR><TR><TD>Proprietary Ratio</TD></TR><TR><TD>Capital Gearing Ratio</TD></TR><TR><TD>Debt Service Ratio</TD></TR></TBODY></TABLE> Sat, 03 Feb 2024 11:18:56 GMT SKA007 2024-02-03T11:18:56Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Formula-for-Finance-KPI/m-p/3677312#M142786 <P>Hi ,</P><P>Can anyone share me the DAX formulas for below Finance KPI Ratio.</P><TABLE><TBODY><TR><TD>GP Margin</TD></TR><TR><TD>EBITDA margin</TD></TR><TR><TD>NP Margin</TD></TR><TR><TD>Current Ratio</TD></TR><TR><TD>Liquidity Ratio</TD></TR><TR><TD>Return on Investment Ratio</TD></TR><TR><TD>Return on Capital Employed Ratio</TD></TR><TR><TD>Earning per Share</TD></TR><TR><TD>Dividend Yield Ratio</TD></TR><TR><TD>Net Profit to Net worth Ratio</TD></TR><TR><TD>Inventory Turnover Ratio</TD></TR></TBODY></TABLE><TABLE><TBODY><TR><TD>Working Capital Turnover Ratio</TD></TR><TR><TD>Fixed Asset Turnover Ratio</TD></TR><TR><TD>Capital Turnover Ratio</TD></TR><TR><TD>Debt Equity Ratio</TD></TR><TR><TD>Proprietary Ratio</TD></TR><TR><TD>Capital Gearing Ratio</TD></TR><TR><TD>Debt Service Ratio</TD></TR></TBODY></TABLE> Sat, 03 Feb 2024 11:18:56 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Formula-for-Finance-KPI/m-p/3677312#M142786 SKA007 2024-02-03T11:18:56Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Formula-for-Finance-KPI/m-p/3677918#M142795 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="684935" data-lia-user-login="SKA007" class="lia-mention lia-mention-user">SKA007</a>&nbsp;Do you have sample data that you can share? Otherwise, it's just the standard formulas for this stuff, such as:</P> <P>GP Margin = DIVIDE( SUM('Table'[Revenue]) - SUM('Table'[Costs]), SUM('Table'[Revenue]) )</P> <P>I have a few of these in the Quick Measure Gallery:&nbsp;<A href="https://community.fabric.microsoft.com/t5/Quick-Measures-Gallery/Gross-Margin-Revenue-and-Cost-GMRC/m-p/584437#M275" target="_blank">Gross Margin, Revenue and Cost (GMRC) - Microsoft Fabric Community</A></P> Sat, 03 Feb 2024 17:15:21 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Formula-for-Finance-KPI/m-p/3677918#M142795 Greg_Deckler 2024-02-03T17:15:21Z