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'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.