Last seen: Jun 27, 2026
Grouping is covered in session 4.16. Index is covered in 4.13, but there are examples of Index being used for various solutions scattered throughout t...
Yes, and variables are covered later in the Power Query course. There is no downside.
Hi Alison, You've only watched 21 of the 71 videos from the course, so I'm not sure which video you're referring to. The Data column is the resu...
Hi Alison, There are various examples of the Index column being used throughout the Power Query course. If you have further questions on Index colu...
Hi Alison, Your first goal should be to get your data into a transaction format where there is a row for every year's contact value i.e. a Tabular ...
Hi Alison, The Index column numbers the days in your Calendar table, it's optional. If you don't need it then I'd leave it out. Session 4.21 exp...
Hi Alison, What video are you referring to having watched? What query and step is the 'Data.Index' column in? I can't see it in the file I attac...
Hi Alison, They're pretty self explanatory and are available on columns with a 'Duration' data type. If you select them you'll see the options in t...
The original method allowed for different markers for overdue, complete etc. which you didn't need. Things that can make a workbook large: - For...
Hi David, You can change your formula to the one below if you just want a 1 to show up where there is activity on a particular date: =IF( CO...
The SourceData query is just your source data with the columns merged, except the Owner column. I also added an Index column. The IssuesPivoted que...
Hi Alison, Can you please share an example Excel file with your data before and then the desired result, so I can see how you get from your current...
You can't transpose some of the columns. It sounds like maybe you want to pivot some of the data? Can you please upload a sample Excel file with yo...
Great! Glad I could help.
Hi Alison, In your 'Desired Result' table Customer A has 4000 (3000+1000) for 2017 and 3250 for 2018, but I can't see which rows in the Contracts t...