Power BI Time Intelligence - Previous Year using DATEADD - Percentage Comparison
Power BI Time Intelligence you can use DATEADD to compare sales with the previous year. That's right! You can see last years sales and compare it with this years sales with the DATEADD function in DAX in other words previous year comparison. The 2 functions we'll use is the DATEADD function, which is a powerful time intelligence. With the DATEADD function you can go back one year or one month or quarter and see what the figures were. You can then use these figures as a comparison.
This Power BI time intelligence tutorial will also show you how to work out a percentage comparison with the previous year. Now as usual should you want to get to the formula you'll find it at around the 4:10 mark.
#computertutoring