Interested to Buy Any Domain ? << Click Here >> for more details...
How would you create trailing x month metrics via dax against a non-standard calendar?
- 1 Answers
- 2 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Please Help Members By Posting Answers For Below Questions
No New Questions to Answer in this Category !! You can
Post New Questions
Answer Questions in Different Category
