DATEADD, SAMEPERIODLASTYEAR - DAX Guide
If you're working with DAX functions, this video guide is a must-watch. Here, you'll learn how to use the DATEADD and SAMEPERIODLASTYEAR functions to manipulate dates in a variety of powerful ways. The DATEADD function allows you to add a specified number of days, months, or years to a given date, while the SAMEPERIODLASTYEAR function lets you compare data from the same period in the previous year.
With these two functions in your DAX arsenal, you can more easily perform a range of common and complex analysis tasks, such as calculating year-over-year growth rates, comparing sales figures between quarters, and more.
So whether you're new to DAX or you're looking to deepen your understanding of this powerful data analysis tool, this guide is an invaluable resource that will help you get the most out of your data.
The link to the guide is: https://www.youtube.com/watch?v=zJa1K0DGkKw
Published on:
Learn more
Related posts
Calculating Dynamic Percentage Of Total Change Using Power BI Time Intelligence
In this tutorial, you'll learn a dynamic approach to computing the Percent of Total Change in Power BI, employing smart measure branching stra...
Comparing Any Sale Versus The Last Sale (No Time Intelligence) – Advanced DAX In Power BI
If you work with Power BI and want to learn an advanced DAX technique, then this tutorial has got you covered. The tutorial demonstrates how t...
Master Time Intelligence In Power BI Using DAX Functions
In this tutorial, the focus is on the combination of DAX functions that can be used for time intelligence calculations. This type of calculati...
Using IsAfterToday for Power BI Time Intelligence Scenarios
In this informative post, you'll delve into the world of Power BI time intelligence scenarios and learn how to use the IsAfterToday function i...
Using Power BI DAX Functions To Deal With Products That Have Changing Prices Overtime
This blog post delves into the practical application of Power BI DAX functions when analyzing products with ever-changing prices. The author t...
The Ultimate DAX Guide For Beginners
If you're new to Power BI development, the world of DAX calculations may seem daunting. But fear not, because this comprehensive DAX guide for...
What is PARALLELPERIOD () DAX function? How to use it? | DAX Sundays | BI Consulting Pro |Power BI
This video from BI Consulting Pro is a helpful guide to understanding and using the PARALLELPERIOD() function in DAX. As someone working with ...
DISTINCT vs VALUES DAX Functions in Power BI | BI Consulting Pro | DAX Sundays | DAX Tutorial | 4K
If you’re looking to up your Power BI game, consider exploring the functionality of DISTINCT and VALUES DAX functions. This video tutorial, pa...
STARTOFMONTH, STARTOFQUARTER, STARTOFYEAR, ENDOFMONTH, ENDOFQUARTER, ENDOFYEAR - DAX Guide
If you're working with DAX formulas in Power BI, it's important to have a solid understanding of time intelligence functions such as STARTOFMO...