Use Case - Rule Syntax for LTD Measure
- 1 Minute to read
- Print
- DarkLight
- PDF
Use Case - Rule Syntax for LTD Measure
- 1 Minute to read
- Print
- DarkLight
- PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
In Practice
You need an LTD (Life to Date) measure. The beginning period is known (the first period of your data load). You have Travel Expenses data for all years beginning January 2017.
Use the following Rule to sum all Travel Expense from JAN-2017 to NOV-2019.
sum({NULL:@CURMTH@},[Measures].[MTD])Was this article helpful?