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.
it seems you get the data from the named range Export (or is it a sheet?) in the Excel - does this range include the October data?
Export1 = Source{[Name="Export"]}[Data],you can change that reference to get the whole sheet
Export1 = Source{[Item="PutTheSheetNameHere",Kind="Sheet"]}[Data],