Forum Discussion
Adding a Standalone Column in a Matrix
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Apologies for not uploading a useable data set. I've recreated some bare bones tables. I'm able to get everything accomplished with the exception of the transfer column in the first screenshot. The Power BI weeks will be dynamic, as weeks go by in the year, a new set of 3 columns will be added for that week (Monday it will have the week of 1/22 data added). I need the transfer column to always be able to be at the end of the other data. Please let me know if you need anything else.
Below is the Google Doc link:
https://docs.google.com/spreadsheets/d/1M8HN4xTh_nB4_fshhxovLQoL0s2ynlF5/edit?usp=sharing&ouid=109857102226483034649&rtpof=true&sd=true