Interested to Buy Any Domain ? << Click Here >> for more details...
How might you make trailing X month measurements by means of DAX against a non-standard timetable?
- 1 Answers
- 15 Views
- I also Faced
- E-Mail Answers
Answer / Km.vijay Laxmi
To make trailing X month measurements against a non-standard timetable using DAX in Power BI, you can create a calculated table that calculates the lagging dates based on your custom timetable. Here's an example of creating a custom date table and calculating trailing 12 months using DAX:
```
Custom Date Table:
Date = CALENDARAUTO()
Custom Month:= DATE(YEAR([Date]),MONTH([Date]),DAY([Date]))
Trailing 12 Months:= CALCULATE(SUMMARIZE('Table', 'Table'[Date], "Total", COUNTROWS('Table')), FILTER('Table', Custom Month <= MAX(Custom Month) && Custom Month >= DATEADD('Table'[Date], -12, MONTH)))
```
Replace `'Table'` with your actual table name.
| Is This Answer Correct ? | 0 Yes | 0 No |
Name the language that is used in power query.
What is power bi publisher for excel?
What are the data destinations for power queries?
What is Power Pivot?
What are many-to-many relationships and how can they be addressed in power bi ?
How might you make trailing X month measurements by means of DAX against a non-standard timetable?
What are the benefits of using variables in dax?
What are the different types of filters in power bi reports?
How is the filter function used?
What is Power BI Desktop?
What is question collapsing in Power Query?
What are some of the differences in report authoring capabilities between using a live or direct query connection such as to an analysis services model, relative to working with a data model local to the power bi desktop file?
QlikView 
