Forum Discussion
Solved
DAX Formula for Finance KPI
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 |
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
1 Reply
- Greg_Deckler
Community Champion
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