This would work as a single DAX measure:
, "CCS After Eval"
Hi Gregory, First, in date table create a column and named it weekDay with this expression:
weekDay = WEEKDAY ( DAY (Calendars[Date]))
than add another column, named lastSaturdayofMonth. use this DAX expression:
astSaturdayofMonth = ...
You DON'T use the date data in your measure about sales. You use the dates to filter/shape the Sales total. The same way you would add a filter for business unit or product.
Make a date table based on the dates in your Sales table. This is the expression ...
At first, I couldn't find it either, but (luckily) it's still available but not in the place where you would expect it. You can find it in the formatting pane of the PAGE in the first section called Page Information There is a dropdown ...
Hi, I really appreciate all the help but I still don't understand how to implement it.
How will I use the week column in my logic? Will I use the MTD built-in function?
In the screenshot below I will add a column with the week number 1 that ...