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
- 14 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
What is a figured segment in Power BI and for what reason would you utilize them?
Is power bi available on-premises?
What are the basics needed for using power bi?
What are the versions of power bi?
What are the power bi dataset, report, and dashboard?
How does SSRS coordinate with Power BI?
What is uncommon or interesting about the CALCULATE and CALCULATETABLE capacities?
What are the three edit interactions options of a visual tile in power bi desktop?
Is it possible to have over one active relationship between two tables in power pivot data model?
What are the features of power bi?
What data sources can power bi connect to?
What are the different excel bi add-in?
QlikView 
