Happy pandemic Forum,
I have a matrix with:
1. A list of 20 deliverables with dates to be delivered (plan sum) and dates they get submitted (sub sum) - these are sourced from two separate spreadsheets connected with a relationship
2. I created (head) columns by "starting-date" week. All random dates are grouped in those weeks
Notice two weeks ago (22 Feb) 3 items were missed / not delivered.
Also last week, (01 Mar) 2 items were missed
I am looking to create a new column (plan sum+) to show the missed items again on shifting current week
I can download the link. But I'm a little bit confused that what results you really need. Can you show me your expected visual in the form of a table?
Thank you for looking into this
I am sending a new link with adjusted data as it matters to see which week the calendar is at currently. I am sending the pbi file and a spreadsheet
The spreadsheet first 2x tabs have the data.
The other 3 tabs have the goal table. One for whenever the current week changes.
@Mike_Mace , You can refer to current week like this
var _St = today() +-1*WEEKDAY( today() ,2)+1
Var _ed = today() + 7-1*WEEKDAY( today() ,2)
calculate(sum(Table[value]), filter(Table, Table[Date] >= _st && Table[End] <= _ed))
Or deal with wow like
Power BI — Week on Week and WTD
Hi @amitchandak ,
Thanks for the quick reply. Not sure I get the column references you are using there and I am not getting very far.
I've applied the measure to a number of columns on pbi file but no luck. Can you direct a little more on this please.
Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.
Watch Session 24 of Ted's Dev Camp along with past sessions!
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.