I have a measure that takes the sum of units sold yesterday. I have another measure that takes the sum of units sold for the day before yesterday (previous day). I’m using a date offset to achieve the logic for these measures, as follows: Sold Qty Yesterday = var soldqtytoday = CALCULATE([Sold Qty…

@pete.langlois , Here’s another one I think you’ll find very relevant and useful: [image] DAX Row minus Previous Row DAX Calculations @Archer , This one ended up being pretty straightforward. We just needed to take our previous measure and add the following filter condit…

Measure based on day of week

DAX DAX Calculations

jbressan March 30, 2021, 8:57pm 3

Hi @pete.langlois

Please check this post, can be useful for you.