Measure based on day of week

[BrianJ]

@pete.langlois,

Here’s another one I think you’ll find very relevant and useful:

DAX Row minus Previous Row

@Archer, This one ended up being pretty straightforward. We just needed to take our previous measure and add the following filter conditions in the PrevDate variable. [image] If we look at 5/23 - 5/26 below, we can see that this is working as expected. Monday picks up the Friday value, but in this case so does Tuesday, since Monday is a holiday (Memorial Day - I’m assuming US holidays, but if you plug in your holiday table column parameter into the extended date table, it will work regardle…

Also, @Greg put together a fantastic DAX Patterns section of the forum on previous value that you should definitely take a look at if you haven’t yet:

Previous Row Value

Often in a Power BI visual one wants to get the value from the previous row to use in a calculation in the current row (e.g., to see if there’s a change between the previous value and the current value). The Previous Row Value DAX pattern can be of help when faced with this issue. As with most situations in Power BI, there are many ways to solve the same problem: here are a couple: Method 1: Add DAX Index Column 1-Add a [DAX Index] calculated column to your table DAX Index = // DAX PATTERN …

I hope this is helpful.

– Brian