TOPN Analysis DAX – Solution

[su_row][su_column size="1/2" center="no" class=""]
In this solution we explain how you can change the current filtercontext of your report to the same period last year or another period like month before. You can easily use the DAX expressions Sameperiodlastyear and Dateadd for this purpose. We show you how you can incorporate this expressions in your report creating added value for your end users
[/su_column] [su_column size="1/2" center="no" class=""]

[video width="1920" height="1080" mp4="https://powerbi-solutions.com/wp-content/uploads/Sameperiodlastyear-Dateadd-Intro.mp4"][/video]

[/su_column][/su_row]

[su_row][su_column size="1/2" center="no" class=""]
In this solution we explain how you can create a datetable in DAX with the most common dimensions. Each datamodel needs a datetable to make sure you can apply time intelligence calculations and filter / visualize your data in the right way. This solution delivers you a ready to use datetable.[/su_column] [su_column size="1/2" center="no" class=""]

[video width="1920" height="1080" mp4="https://powerbi-solutions.com/wp-content/uploads/Datable-Intro-www.powerbi-solutions.com_.mp4"][/video]

[/su_column][/su_row]

[su_row][su_column size="1/2" center="no" class=""]
In this solution we explain how you can analyze your running totals per year / quarter and month. These expressions are very helpful to compare your current reporting period to a previous period. We also explain how to compare an ongoing period with the same range of dates in the previous period.
[/su_column] [su_column size="1/2" center="no" class=""]

[video width="1920" height="1080" mp4="https://powerbi-solutions.com/wp-content/uploads/YTD-QTD-MTD-www.powerbi-solutions.com_.mp4"][/video]

[/su_column][/su_row]

[su_row][su_column size="1/2" center="no" class=""]
In this solution we explain how you can create a dynamic report by using driving tables. These driving tables make it possible to change which data is shown in your visuals. So you can change for example your comparing figures from last year to budget with just one click. Driving tables are an alternative way to solve this instead of using bookmarks.
[/su_column] [su_column size="1/2" center="no" class=""]

[video width="1920" height="1080" mp4="https://powerbi-solutions.com/wp-content/uploads/Driving-tables-www.powerbi-solutions.com_.mp4"][/video]

[/su_column][/su_row]