Forum Discussion
Non Repeating Matrix Columns
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
This is what I'm trying to create:
Invoice Month Baseline Budget Jan-25 Feb-25 Mar-25 Q1 Budget Q1 Acutal Q1 Difference Department 1 $565.00 $600.00 $400.00 $600.00 $1,695.00 $1,600.00 ($95.00) --- Sub Dept $100.00 $100.00 $200.00 $200.00 $300.00 $500.00 $200.00 --- Sub Dept 2 $465.00 $500.00 $200.00 $400.00 $1,395.00 $1,100.00 ($295.00) Department 2 $955.00 $236.00 $200.00 $332.00 $2,865.00 $768.00 ($2,097.00) Department 3 $6.00 $655.00 $100.00 $11.00 $18.00 $766.00 $748.00 Department 4 $55.00 $64.00 $300.00 $44.00 $165.00 $408.00 $243.00 Totals $2,146.00 $2,155.00 $1,400.00 $1,587.00 $6,438.00 $5,142.00 ($1,296.00) So there is a static start column and add the end 3 columns, ideally these would then get repeated for each quarter, my field well is shown below, if I add an additional column under the date it then gets included even if I force the data blank.
Downloads aren't working on the forum since the upgrade, but I created another table and foced my columns in that seemed to work however when the data is drilled the sum stops working and I'm unsure how to handle the additional months, I started looking at calculation groups but haven't got it working yet
Thanks in advance
