DAX Tutorial in Power BI | SamePeriodLastYear|Time Intelligence
#powerbitraining #dax #powerbi
This video teaches the DAX Function called SamePeriodLastYear in Power BI to viewers with an easy Practical demonstration in Desktop. The SamePeriodLastYear belongs to the family of time intelligence functions in Power BI DAX.
SamePeriodLastYear year returns a table containing a date column just shifted one year back .
See the use of the word PERIOD in this function .It does not specify which period to use for calculation .
Hence it can be used to get the Sales for:
1.One year back or
2.Same Quarter Previous Year
3.Same Month Previous Year
We will see each of these examples in this video .
The syntax -- SAMEPERIODLASTYEAR(dates)
What does the second parameter mean?
Dates – A column that contains dates.
Practical Example using Power BI desktop is also covered in this video.
Other Useful Power BI tutorial Videos:
OTALYTD Vs DATESYTD : • Complete Time Intelligence Tutorial in Pow...
SUM Vs SUMX: • Power BI SUM Vs SUMX | Dax Functions
Row Vs Filter Context : • Row Context Vs Filter Context in Power BI
