How might you make trailing X month measurements by means of DAX against a non-standard timetable?
- 1 Answers
- 85 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 |
What are a portion of the distinctions in report creating capacities between utilizing a live or direct question association, for example, to an Analysis Services demonstrate, in respect to working with a data display nearby to the Power BI Desktop document?
How one can get started with power bi?
What are many-to-numerous connections and how might they be tended to in Power BI ?
What are the basics needed for using power bi?
What are the features of power bi?
What is self-service business intelligence?
What are some ways that excel experience can be leveraged with power bi?
What is DAX?
What are the significant components of power bi?
Which dialect is utilized as a part of Power Query?
What data sources can be connected to for power bi?
What are the contrasts between a Power BI Dataset, a Report, and a Dashboard?
QlikView 
