previous week comparison
1 Topic
How to get Previous Custom Week end date
Hi everyone, I'm fairly new to Power BI and DAX and haven't found a solution that fits my current problem. I'd like to calculate the totals for previous week. My date table contains the custom week end column. For example if date 4th November 2020, the custom weekend date is 8/11/2020. I'd like to find out if there's a way to compare to the total from previous week end date depending on the selected date on the filter. If the user selects 28 October 2020, I'd like to find out the total from previous week = 25/10/2020. Any help or advise will be really appreciated.Solved2.1KViews0likes2Comments