neep help

2 Topics

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( ([Rolling12MonthAdjustedEBITDA] - [Rolling 12 Month Cash Taxes] - [Rolling 12 Month Capital Expenditures]) / [Rolling 12 Month Interest Expense] ) Rolling12MonthAdjustedEBITDA= CALCULATE [Adjusted EBITDA], DATESBETWEEN (DateTable[Date], NEXTDAY (SAMEPERIODLASTYEAR ( LASTDATE (DateTable[Date]))), LASTDATE (DateTable[Date]) Rolling 12 Month Cash Taxes= CALCULATE [Total Cash Taxes], DATESBETWEEN (DateTable[Date], NEXTDAY (SAMEPERIODLASTYEAR ( LASTDATE (DateTable[Date]))), LASTDATE (DateTable[Date]) Rolling 12 Month Capital Expenditures= CALCULATE [Total Capital Expenditures], DATESBETWEEN (DateTable[Date], NEXTDAY (SAMEPERIODLASTYEAR ( LASTDATE (DateTable[Date]))), LASTDATE (DateTable[Date]) Rolling12MonthIntrest = CALCULATE [Total CapitalExpenditures], DATESBETWEEN (DateTable[Date], NEXTDAY (SAMEPERIODLASTYEAR ( LASTDATE (DateTable[Date]))), LASTDATE (DateTable[Date]) Any assistance will be much appreciated!
Solved
garzajnc24
2 years ago Place DAX Commands and Tips
1.6KViews
0likes
4Comments
Date Table: To use start of and end of year dates or not
If I am creating a date table does the table contain dates from the beginning of the year to the end of the year even if those dates don't exist in the fact table. e.g. fact table date range: 02/02/2022 - 01/06/2023 date table range: 01/01/2022 - 31/12/2023 this is recommended by most power bi instructors and tutors online. But when using date related dax functions the date table becomes disfunctional. An example of a date function when this happens: Last 12 Months V1 = CALCULATE ( [Total Sales], DATESINPERIOD ( 'Date'[Date], -- returns period from date column MAX ( 'Date'[Date] ), -- starting from MAX date -12, -- shifting it back 12 intervals MONTH -- each interval being a month ) ) Am I missing something? or do you create a copy date table for dax functions?
Solved
akhaliq7
3 years ago Place DAX Commands and Tips
1.9KViews
0likes
7Comments