Forum Discussion
Resolver Inew column for matrix with weekly-live items
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
6 Replies
- amitchandak
Super User
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-Last-Week/ba-p/1051123
https://www.youtube.com/watch?v=pnAesWxYgJ8
Mike_MaceHi 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.
plan+ =var _St = today() +-1*WEEKDAY( today() ,2)+1Var _ed = today() + 7-1*WEEKDAY( today() ,2)returncalculate(sum('plan date'[plan sum]), filter('Date Calendar', 'Date Calendar'[Date Calendar] >= _st && [failed] <= _ed))
v-cazheng-msftCommunity Support
- Mike_Mace
- v-cazheng-msft
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
