How would you create trailing x month metrics via dax against a non-standard calendar?
- 1 Answers
- 78 Views
- I also Faced
- E-Mail Answers
Answer / Rahul Bhaskar
To create trailing n-month metrics using DAX on a non-standard calendar, you can use the CALCULATE and LAST function. You'll first need to define your custom calendar table, then create a measure that calculates the required metric for the current row and the previous 'n' rows by using the LAST function within the CALCULATE statement.
| Is This Answer Correct ? | 0 Yes | 0 No |
What are some ways that Excel experience can utilize with Power BI?
What are the distinctive sorts of invigorating data for our distributed reports?
What is Power View?
How does ssrs integrate with power bi?
What are inquiry parameters and Power BI layouts?
What is the need of signing up with work email?
What are the different types of refreshing data for our published reports?
What are the most common dax functions used?
What are some common power query/editor transforms?
What are the different types of filters in power bi reports?
Which language is used in power query?
For what reason may you have a table in the model with no connections to different tables?
QlikView 
