Forum Discussion

garzajnc24's avatar
garzajnc24
Frequent Visitor
2 years ago
Solved

Fixed Charge Coverage Ratio (FCCR)

Hello all.   I need assistance with this ratio measure in PowerBI.    Here is the breakdown of my measures from top to bottom: FCCR =     CALCULATE(         ([Rolling12MonthAdjustedEBITD...
Measures
Neep Help
  • garzajnc24's avatar
    garzajnc24
    2 years ago

    I managed to figure out what the problem was. The issue was the source data and not the measures. Thank you.

mark_endicott's avatar
mark_endicott
Icon for Super User rankSuper User
2 years ago

garzajnc24 - I'm going to work on the assumption your problem is with the first 3 months of 2018 showing "Infinity". This is likely to do with your source data. 

 

But also, assuming all your other calculations are correct (we have no base data to test). Instead of your FCCR measure I would use the below, it's more optimal, and it handles divide by 0 errors. 

 

DIVIDE(
        ([Rolling12MonthAdjustedEBITDA] - [Rolling 12 Month Cash Taxes] - [Rolling 12 Month Capital Expenditures]), [Rolling 12 Month Interest Expense], 0
    )

 

Perhaps if this doesnt fix your issue, you can provide some detail over what is wrong, and some sample data. 

  • mark_endicott's avatar
    mark_endicott
    Icon for Super User rankSuper User
    2 years ago

    garzajnc24 - I've also noticed your rolling 12 month measures are missing some brackets at the end, but I'm sure you're aware of that. They should be in the format below (note I have changed the date table to match my test model):

     

     

    CALCULATE (
    [Total Sales],
    DATESBETWEEN (
        'Date'[Date],
        NEXTDAY ( SAMEPERIODLASTYEAR ( LASTDATE ( 'Date'[Date] ) ) ),
        LASTDATE ( 'Date'[Date] )
    )
)

     

    • garzjnc's avatar
      garzjnc
      Frequent Visitor
      2 years ago

      Thank you, mark_endicott I will try these suggestion and provide sample source data, if that does not work. My issue is numbers are not reconciling with excel report up to rolling 12 month totals.