My Dataset is simple - I have 3 products (A,B,C) and I have dates from Jan-01-2020. I also have product-wise quantities for each day. I need to show 1. % change in quantity daily (with reference to March-17-2020, previous day comparison is march-16-2020(quantity = 12) vs march-15-2020 (quantity =…

My bad forgot to make the offset dynamic to your selection. So I added a variable to identify the MonthOffset for [Yesterday’s date] to solve that. Last Month's date = VAR Yesterday = [Yesterday's date] VAR Yoffset = LOOKUPVALUE( Dates[MonthOffset], Dates[Date], Yesterday ) VAR LastMonth = CA…

Change yesterday vs day before, yesterday vs last week, yesterday vs last month

DAX DAX Calculations

BrianJ March 17, 2020, 10:48pm 3

@satichun,

In addition to the resources that @Melissa suggested, you may find this thread helpful as well:

Brian