Answer Posted / 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.

No New Questions to Answer in this Category !!    You can

Post New Questions

Answer Questions in Different Category