DAX Formula for Finance KPI

[SKA007]

Hi ,

Can anyone share me the DAX formulas for below Finance KPI Ratio.

GP Margin

EBITDA margin

NP Margin

Current Ratio

Liquidity Ratio

Return on Investment Ratio

Return on Capital Employed Ratio

Earning per Share

Dividend Yield Ratio

Net Profit to Net worth Ratio

Inventory Turnover Ratio

Working Capital Turnover Ratio

Fixed Asset Turnover Ratio

Capital Turnover Ratio

Debt Equity Ratio

Proprietary Ratio

Capital Gearing Ratio

Debt Service Ratio

[Greg_Deckler · Accepted solution]

@SKA007 Do you have sample data that you can share? Otherwise, it's just the standard formulas for this stuff, such as:

GP Margin = DIVIDE( SUM('Table'[Revenue]) - SUM('Table'[Costs]), SUM('Table'[Revenue]) )

I have a few of these in the Quick Measure Gallery: Gross Margin, Revenue and Cost (GMRC) - Microsoft Fabric Community