Power BI DATEADD & SAMEPERIODLASTYEAR | Month Comparison & Quarter Comparison| Month on Month PBI
This is a detailed video on how to use time intelligence function to do data comparison across two or more time periods.
With the help of simple example and using functions like DATEMTD, DATESQTD, DATEADD and SAMEPERIODLASTYEAR i have tried to explore how we can do Month on Month comparison, Quarter on Quarter comparison and Quarter Current year with Quarter Previous Year.
This is a lengthy video and please bear with me.
You can skip to 14:56 where all the functions are shared in a notepad.
Other Videos which you might be interested:
1. Summarize Columns : • Power BI SUMMARIZECOLUMNS function
2. Change the color of Selected Button : • Power BI Change Button Color on Selec...
3. Hide and Unhide Visuals to optimize space : • Power BI Hide and Unhide Visuals | Us...
4. Earlier function : • Power BI EARLIER function
5. Selected Measure or Calculated group : • Power BI SELECTEDMEASURE or CALCULA...
6. DatesMTD, DatesQTD, DatesSYTD : • Power BI DATESMTD, DATESQTD and DATESYTD
7. Targets & Trend : • Power BI Measures shown in Rows in Ma...
8. Blank, Isblank, Isnumber, Istext : • Power BI BLANK, ISBLANK, BLANK with I...
9. Select Columns : • Power BI SELECTCOLUMNS function
10. Divide by Zero Error Handling : • Power BI Divide by Zero Error| Divide...
11. Mean , Median, Mode : • Power BI Mean(Average), Median & Mode...
12. Many to many relationship : • Power BI Many to Many Relationship
13. Count working days, exclude holidays : • Power BI Network days | Count Busines...
14. Weekly Rolling average : • Power BI Weekly Rolling Average | Wee...
15. Enable tabular editor : • Power BI Enable EXTERNAL TOOLS like T...
16. Add Columns : • Power BI ADDCOLUMNS function
17. Contains, Containsstring : • Power BI CONTAINS, CONTAINSSTRING & C...
18. Variance & Standard Deviation : • Power BI VAR.S and STDEV.S | Variance...
19. Row Number : • Power BI Row_Number Over Partition by...
20. Summarize : • Power BI SUMMARIZE function