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 Capi...
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
Greg_Deckler
Community Champion
Community ChampionSKA007 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