Forum Discussion
Data Column Refresh After Unpivot
Hello all, I have a set of data in Power BI that has months in the columns (Jan, Feb, Mar etc..) everymonth I run the report to get the current month data. So, when I created the report I had al...
im not sure how to attach a worksheet but, here are the first two rows and their columns.
| Created: 29.10.2018 | Subtotal | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||
| Employee / Facility Res-Grp | Project No. | Project Description | PFP | Order Category | WPI No. | Task ID | Task Name | Org Office | Resource Group | Kind of Activity | Jan 18 | Feb 18 | Mar 18 | Apr 18 | May 18 | Jun 18 | Jul 18 | Aug 18 | Sep 18 | Oct 18 | Nov 18 | Dec 18 |
I tell BI to remove the first row. It is there for people who want a quick view of the report without looking at BI.
Have you a pivot table in excel, correctly?
Check if the october is in pivot table range.
It may not be in range...so I need to delete the step of the unpivot and repivot, correct?
You need to change the range of pivot table in excel file