Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Hi @Mike_Mace
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?
Best Regards
Caiyun Zheng
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
measure =
var _St = today() +-1*WEEKDAY( today() ,2)+1
Var _ed = today() + 7-1*WEEKDAY( today() ,2)
return
calculate(sum(Table[value]), filter(Table, Table[Date] >= _st && Table[End] <= _ed))
Or deal with wow like
Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-La...
https://www.youtube.com/watch?v=pnAesWxYgJ8
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.
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |