How to work out Previous Year to Date in Power BI?
How to work out Previous Year To Date in Power BI? You know that there is a DATESYTD function to calculate the year to date but maybe you would like to work out a formula for calculating year to date for the previous year. Once you can do this then you can formulate a comparison formula to work out a percentage increase or decrease over the last year to date.
If you want to download the exercise file you can do so from:
www.computertutoring.co.uk/power-bi-year-to-date.asp
If you want to get straight to the formula you can do so at timestamp: 07:20
00:00 Introduction
00:53 DimDate table
01:05 Create a measures table
02:20 Create a matrix
03:00 Increase text size
03:15 Drill down
03:29 Create a previous year and a previous year to date
04:30 Create a measure for previous year
06:00 Calculate year to date for previous year
07:20 Calculate previous year to date in one function
09:00 Work out a YTD percentage difference
#computertutoring
😊 Check out my website and social media to keep up to date - enjoy learning 😊
📱 http://www.computertutoring.co.uk/ 📱
📽 / thecomptutor 📽
👨👩👧👦 / computertutoring.co.uk 👨👩👧👦
🦉 / ct_tutoring 🦉
📷 / computer_tutoring 📷
📌https://www.pinterest.co.uk/CT_Training/ 📌