Forum Discussion
Like for Like calc based on a single data set across multiple time periods. adding calc table
Hi, I am new to this community and struggling with a time period like for like calc. Please Help 🙏 I have a data set with various information, including a single date column, column for custo...
lbendlin
Super User
Super UserIncidentally Alberto has just talked about that in his new video
Checking Boolean conditions while creating a like for like comparison in DAX – Unplugged #36 - SQLBI
Hi lbendlin Thank you so much for coming back to me.
Yes i'd watched this video a couple weeks back as this was the solution i used as my first attempt.
The issue here though is that it only looks one way. By this i mean it only looks at the first year and then if values are done in the following year.
I need a solution that only considers customer codes with values shown in both time periods.
- lbendlin
Watch the video again. It goes deep into the intricacies of properly identifying like for like data ( well, minus the weekday issue).