Sameperiodlastyear/Dateadd DAX – Solution
Sameperiodlastyear/Dateadd DAX – Solution
Sameperiodlastyear/Dateadd DAX – Solution
Sameperiodlastyear/Dateadd 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=""]
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]
TOPN Analysis DAX – Solution
TOPN Analysis DAX – Solution
TOPN Analysis DAX – Solution
TOPN Analysis DAX – Solution
[su_row][su_column size="1/2" center="no" class=""]
In this solution we explain how you can analyze which customers / products etc. are the most important for your company. We are using the expressions RANKX and TOPN to create dynamic TOPN lists, so you can easily analyze where you need to pay attention to. This is also very helpful to pay only attention in your report tot the main deviations instead of all your data.
[/su_column] [su_column size="1/2" center="no" class=""]
In this solution we explain how you can analyze which customers / products etc. are the most important for your company. We are using the expressions RANKX and TOPN to create dynamic TOPN lists, so you can easily analyze where you need to pay attention to. This is also very helpful to pay only attention in your report tot the main deviations instead of all your data.
[/su_column] [su_column size="1/2" center="no" class=""]
[video width="1920" height="1080" mp4="https://powerbi-solutions.com/wp-content/uploads/TOPN-Analysis-www.powerbi-solutions.com_.mp4"][/video]
[/su_column][/su_row]
YTD/QTD/MTD DAX – Solution
YTD/QTD/MTD DAX – Solution
YTD/QTD/MTD DAX – Solution
YTD/QTD/MTD DAX – Solution
[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=""]
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]