Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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 |
Solved! Go to 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
@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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
21 | |
15 | |
14 | |
11 | |
7 |
User | Count |
---|---|
25 | |
24 | |
12 | |
12 | |
11 |