Last seen: Dec 22, 2025
In the attached file, change the path to your sample file in the "Test" query. Basically, the idea is to add a new column to identify the target he...
Hi Jason, Nothing attached. Rather than a picture, can you create a file with sample data? Will be much easier to help you.
Ok, so Modification 1 has the finish date of FINISH 2 ?! What's the order of the operations, as it's not as obvious as you may think. The date column ...
Hi Charlie, There is no attachment, please try again attaching the files, use also the Start Upload button, not just the select files button.
Hi Steven, You have to specify all possible scenarios to view or hide that shape, If-Then-Else might not be enough. use ElseIf: If Month(Date) &...
Hi Bob, Try to increase the Timeout parameter to 2-3 minutes, that web server might be very busy. Web.Contents("your URL here", [Timeout=#durati...
hi Jaryszek, You have to use the Power Query documentation, but you cannot set single precision/double precision or double extended in PQ, use only...
Hi Victor, You have: MODIFICATION 1- Start Date: 1/1/2003 , Salary: 1091.25 In your desired output, from where is Finish Date coming from, no...
#table needs lists as arguments. This is already a table: Source= Excel.CurrentWorkbook(){[Name="MainNR"]}[Content][Column1] You don't need {...
Hi Sofie, Here are some resources related to pivot conditional formatting. Make sure your pivot are properly formatted according to this article, ...
Hard to say, you might have to move the files from the SP folder, put there only 1 file and refresh the query, until one of them fails, this way you c...
First, read the source table and load to output worksheet. For now, it's just a mirror of the source table. Next, go to the sheet with the output t...
Hi Katie, I don''t know the reason, as it's not documented anywhere, all you can do is to add to a new worksheet then cut the table and paste it wh...
Hi Julie, The problem is explained here: You will also find some workarounds there.
No worries, you can add as many messages you want, if the issue is not solved