Hello,
I need help with a Dax query for the following situation:
Each week funding data for that particular week is added to a running report with the week date that it's downloaded listed in a field. Each new week will have duplicates from the prior weeks + any changes in the funding report for that week. So for Period 1, I need to capture only the last week of data that was pulled and maintain that total throughout the year for all periods that exist in a table. It gets tricky since it's a running report, for example, next week the DAX query will need to pick up the following
Period 1 = Week 4 (4th wk of the month)
Period 2 = Week 8 (4th wk of the month)
Period 3 = Week 12 (4th wk of the month)
Period 4 = Week 17 (5th wk of the month)
Period 5 = Week 21 (4th wk of the month)
Period 6 = Week 25 (4th wk of the month)
Period 7 = Week 30 (5th wk of the month)
Period 8 = Week 31 (1st wk of the month) since this is all that's past so far
I have tried summarized tables pulling last date but it just shows the last date of that period and still summarizes all 4.
Any ideas?
