I have a payroll table and a budget table for accounts, both contain account numbers and daily amounts in addition to a date column. I have a date table with various columns related to the date, including one that has the week ending date for any date in the regular date column. Now I can create a matrix with accounts as the rows and week ending dates as the columns. However what I haven't been able to figure out yet is how to filter the data so that it only pulls data for the last full week's week ending date. This information would be found in the payroll table, where it would only have payroll information for the last day for which it was updated. Can someone help me with a DAX command or other way to accomplish this goal? Of course I could get the result I want with a filter applied to the visual, but I would like it to be automatic for my client's use.
- Craig
