Forum Discussion
Last year comparison logic with ERP data
A little update, I managed to create a date table as suggested by amitchandak and was able to successfully make use of SAMEPERIODLASTYEAR. It was a trial and error process and several attempts were made at making my own date table and having done that really fortified the concept. Even so, I kept having small issues. Then I came across an open source project called Bravo for Power BI which created a calendar table in my Power BI project much better than I could have possibly done on my own with tons more options relating to localizations and also introduced a lot of handy time intelligence measures as part of the process. I'm a very happy camper.
A little update, I managed to create a date table as suggested by amitchandak and was able to successfully make use of SAMEPERIODLASTYEAR. It was a trial and error process and several attempts were made at making my own date table and having done that really fortified the concept. Even so, I kept having small issues. Then I came across an open source project called Bravo for Power BI which created a calendar table in my Power BI project much better than I could have possibly done on my own with tons more options relating to localizations and also introduced a lot of handy time intelligence measures as part of the process. I'm a very happy camper.