The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi PBI Community,
I have data in the following format:
Name | Week Start | Week End | Total Coaching Received |
John | 12/26/2021 | 1/1/2022 | 0 |
John | 1/2/2022 | 1/8/2022 | 1 |
John | 1/9/2022 | 1/15/2022 | 1 |
John | 1/16/2022 | 1/22/2022 | 0 |
John | 1/23/2022 | 1/29/2022 | 2 |
John | 1/30/2022 | 2/5/2022 | 0 |
John | 2/6/2022 | 2/12/2022 | 0 |
John | 2/13/2022 | 2/19/2022 | 0 |
John | 2/20/2022 | 2/26/2022 | 2 |
John | 2/27/2022 | 3/5/2022 | 1 |
Mary | 12/26/2021 | 1/1/2022 | 2 |
Mary | 1/2/2022 | 1/8/2022 | 1 |
Mary | 1/9/2022 | 1/15/2022 | 3 |
Mary | 1/16/2022 | 1/22/2022 | 0 |
Mary | 1/23/2022 | 1/29/2022 | 0 |
Mary | 1/30/2022 | 2/5/2022 | 1 |
Mary | 2/6/2022 | 2/12/2022 | 0 |
Mary | 2/13/2022 | 2/19/2022 | 0 |
Mary | 2/20/2022 | 2/26/2022 | 0 |
Mary | 2/27/2022 | 3/5/2022 | 1 |
Bill | 12/26/2021 | 1/1/2022 | 3 |
Bill | 1/2/2022 | 1/8/2022 | 1 |
Bill | 1/9/2022 | 1/15/2022 | 2 |
Bill | 1/16/2022 | 1/22/2022 | 1 |
Bill | 1/23/2022 | 1/29/2022 | 3 |
Bill | 1/30/2022 | 2/5/2022 | 0 |
Bill | 2/6/2022 | 2/12/2022 | 0 |
Bill | 2/13/2022 | 2/19/2022 | 1 |
Bill | 2/20/2022 | 2/26/2022 | 2 |
Bill | 2/27/2022 | 3/5/2022 | 3 |
I am trying to calculate a running week % total for each month of people that received 4 or more coaching in the month, but I want to show it as a running % total by the week, resetting it of course when it's the new week and month.
The goal is to have a visual where I'd have the week starts on the x-axis and then the running %, so as the month goes along, that % should increase with each successive week in that month, and would reset when it's a new month.
Solved! Go to Solution.
Your first problem is that a week is not compatible with a month. What should happen to the Coaching numbers are in a week that stretches two months?
Your first problem is that a week is not compatible with a month. What should happen to the Coaching numbers are in a week that stretches two months?