Forum Discussion
Offset and variables
Hi everyone, I am new to PowerBI and am trying to get ideas for making my work routine easier. I want to make a variable for last week with OFFSET and then, make week on week for comparison as belo...
lbendlin
Super User
Super Useryyyyww will not work across year boundaries. Instead, use steps of 7 on your day column, and use WINDOW instead of OFFSET.