Forum

Hi Larry, With the List.DateTime function: e.g. = List.DateTimes(#datetime(2019, 01, 01, 00, 00, 0), 744, #duration(0, 1, 0, 0)) Will give...

Hi Mike, Yes, giving up the ability to drill down to lower date levels of granularity simplifies the solution significantly. You need a date tab...

Hi Kasey, You need to use the Date.AddDays function to adjust the date e.g. if Date.AddDays([#"[RCT]Date Received (Date)"],-5) <= [#"[PO]Due ...

Hi Sal, As I said: "Note: I added the Course and Time columns as text, but you could use a conditional column to add them automatically if you want...

Hi Melanie, You shouldn't have separate columns for the quarters/months etc. This is the cause of your problems. You should have one column with th...

Hi Michael, You need to use Power Pivot for this. I see you haven't started the course yet, but you will need to get through to the Time Intelligen...

Hi Sal, Please see file attached. Note: I added the Course and Time columns as text, but you could use a conditional column to add them automatical...

Hi Amaro, The formula uses the TODAY function in the MIN formula to find the earliest day between the end of accident leave, the end of the month t...

Hi Amaro, Please see attached. Note, Tables cannot have dates as the column labels, so I have inserted a row above the table with a proper date for...

Hi Sal, Can you please attach your file here. Thanks, Mynda

Good idea, Catalin. Junko, you can see this process in the second video on the page for lesson 2.05.

Hi Junko, The sheet tabs in each file have different names, so it can only find the data in the first file because it's then looking for sheet tab ...

In that case, move the source data to a folder they don't have access to. If they refresh the query it'll return an error. Make sure they can only ope...

Hi Hitesh, Can you please upload a sample Excel file containing some examples? I'm not sure where this 50+50 or 80+20 information is coming from. I...

Hi Paul, Use Power Query to get the data from the external file and load it to the Pivot Table as a connection only. Power Query is the opposite in...