I've done this by using Access to create a query ("PQSource") that will act as the source in Power Query The original data table is linked to the C...
After merging is it the rule to then unpivot all columns before putting in power pivot
Would you recommend this is done in power query or once the data is in power pivot
Also how would you delay the phasing = eg IT Salary value is for the months April - Dec therefore the phasing should start in April
Looking at the solution you have sent for my previous version question the calendar table in there starts with a Min Max. date from the source data. ...
Thanks. The last paragraph answers the question but I couldn’t see how it was getting to that. I thought it may have been looking at something from ...
The power query videos The file you sent - I added a step to expand the data column to try and work out what was happening in the background by I’...
Re index column. Why would I need it? What scenarios would it be used in?
The dates to be 5 years in advance. So my date table starts at 1/1/15 and will run to 15/12/2023
I've watched the video but still unsure what it is doing. What is the Data.Index column representing? How does it work out the numbered column