Forum

You can use a merge to bring in the extra dates. Then merge those columns and split into rows. See file attached. Mynda

Hi Alan, Thanks for sharing your file and a mock-up of what you're trying to achieve. This makes your question very clear. If the split of bands...

Hi Liam, You're on the right track, you can use this formula: =CALCULATE( MAX([Report Date]), Table1[Line Status]="Entered" ) M...

Hi Bob, Yes, I'm sure you could write some VBA to automatically format the data into tables or named ranges. The Table.ExpandTableColumn functio...

Hi Ron, If you just want one workbook per query then you'd use Get Data > From Excel File. You'd have to create a separate query per file manual...

Hi Junko, Yes, this is just a limitation of the version of Excel you have. You should be able to update Excel and get the newer Power Query feature...

Hi Michael, To clarify, at March 2018 you'd want to do this: =March YTD 2018/March YTD 2017 or =March YTD 2018/Dec YTD 2017 ? Mynda

Hi Jason, Sorry, I ready your question; 'which tutorial do I refer to the Quick Measures Community Page', not 'what is the URL for the Quick Measur...

Hi Gad, If you want to do some video tutorials then I recommend using Camtasia Studio to do the screen capture. This is what I use. You can then ho...

Hi Bob, If you want to consolidate the data into a new worksheet in the current file then the data in each worksheet either needs to be in an Excel...

Hi Lea, Power View has been deprecated, which is why it's hidden in later versions of Excel. It is only available for backward compatibility and as...

Hi Dwight, Excel isn't designed to be used this way, which is why you're having trouble. If you change your approach and insert the dive order o...

Hi Jason, Session 3.06 Creating Measures & Quick Measures. Mynda

Hi Larry, I think you want this (see changes in red): = List.DateTimes(#datetime(2018, 01, 01, 00, 00, 0), Duration.Days(DateTime.Date(DateTime....

Hi Mardi, I'd have two tables; Time Sheets and Pay Rates. The Pay Rates table will contain the employee details like employee ID, name, rate, ra...