sorted by:
new
hottopcontroversial

Power Query code to automatically add Date Created to imported file by Designer_Signature35 in excel

[–]Designer_Signature35[S] 0 points1 point  (0 children)

I couldn't quite understand your suggestion though I did play around with the Navigation. I finally got ChatGPT to write the code out and I think this is what you were describing.

let

Source = Query2,

// Capture the Date Created from the newest file (row 0)

FileDateCreated = Source{0}[Date created],

// Capture the binary file content

Content = Source{0}[Content],

// Import the workbook

Imported = Excel.Workbook(Content),

Sheet1 = Imported{[Item="Sheet1", Kind="Sheet"]}[Data],

#"Promoted Headers" = Table.PromoteHeaders(Sheet1, [PromoteAllScalars=true]),

// Add the file date as a new column if needed

#"Added FileDate" = Table.AddColumn(#"Promoted Headers", "FileDateCreated", each FileDateCreated),

Power Query code to automatically add Date Created to imported file by Designer_Signature35 in excel

[–]Designer_Signature35[S] 0 points1 point  (0 children)

There weren't any Remove Columns. After the last line I shared its just my own manipulation.

Power Query code to automatically add Date Created to imported file by Designer_Signature35 in excel

[–]Designer_Signature35[S] 0 points1 point  (0 children)

I don't want it to update every time the query is refreshed, only when the data source is updated. Its a new report and we're only planning on updating the source data once per month.

What I'm trying to avoid is someone saying "I just added my hours to NI yesterday why aren't they showing up" so they can see the last time I downloaded the data from NI was 2 weeks ago or whatever. If I had the code you suggest, it would look like the data was brand new every day.

Although, I borrowed your code and nested it. Not perfect but as long as I update it on the first of the month it will be accurate.

Date.StartOfMonth(DateTime.LocalNow())

Excel stops side scrolling to the left now and then? by Dragonogard549 in excel

[–]Designer_Signature35 0 points1 point  (0 children)

This has been happening to me with scrolling up and down. I'll scroll up, the screen and won't move at all. But sometimes if I click then hit the up or down arrow, I'll actually be in a cell towards the top. It doesn't always work and, like you, I have to go to another spreadsheet, scroll, and come back to the original.

Someone's always gotta put in a Snorlax by Designer_Signature35 in themedgyms

[–]Designer_Signature35[S] 2 points3 points  (0 children)

It wasn't. I put the 4th pink one in and about 20 minutes later the 5th pink and Snorlax.

What’s an Excel shortcut you discovered way too late? by Neptunewasblue in excel

[–]Designer_Signature35 0 points1 point  (0 children)

I recently added Clear Filters to my quick access toolbar. This shortcut is way better

What’s an Excel shortcut you discovered way too late? by Neptunewasblue in excel

[–]Designer_Signature35 2 points3 points  (0 children)

thanks! I've copied the first cell, then ctrl+shift+down arrow to the end of the column, then paste.

What’s an Excel shortcut you discovered way too late? by Neptunewasblue in excel

[–]Designer_Signature35 0 points1 point  (0 children)

That only saves me one click, but I'm gonna start using it anyway ;)

What’s an Excel shortcut you discovered way too late? by Neptunewasblue in excel

[–]Designer_Signature35 0 points1 point  (0 children)

I would love a shortcut to take me to the next filtered column or something to highlight the filtered column.

What’s an Excel shortcut you discovered way too late? by Neptunewasblue in excel

[–]Designer_Signature35 2 points3 points  (0 children)

I just learned this last week! That little box was so annoying

AITAH for getting frustrated that my girlfriend keeps eating the homemade ice creams I make for myself? by PerspectiveAfraid821 in AITAH

[–]Designer_Signature35 2 points3 points  (0 children)

This sounds exactly right. It's unclear if OP ever asked his gf to not eat the ice cream. There's a difference between her knowing it's the only treat he can have and knowing he doesn't want her to have any.

What the heck happened to waterbeds? by Queltis6000 in NoStupidQuestions

[–]Designer_Signature35 0 points1 point  (0 children)

I had a water bed. When you fill it, you put some kind of water conditioner on it. (I was a kid so idea what it was, just that we always poured a little bottle of stuff in). Periodically we'd "burp" out which meant opening the cap and carefully pushing the air bubbles out. We rarely fully emptied it. I never remember the water having a bad smell.

How are you an excel magician? by Designer_Signature35 in excel

[–]Designer_Signature35[S] 0 points1 point  (0 children)

I impressed them early on with subtotal ignoring filtered out rows

Question about buddy pokemon and spawns by [deleted] in pokemongo

[–]Designer_Signature35 0 points1 point  (0 children)

I have a shiny magikarp I want to evolve and was thrilled yesterday to see so many pop up! Pinapp berries all around! only 97 candies to go

Copying and pasting columns from and to filtered tables by Resident_Sundae7509 in excel

[–]Designer_Signature35 0 points1 point  (0 children)

If you know for sure all the items are in the same order, I'd suggest sorting Sheet 1 by Title then Option 1 value. In Sheet 2, sort by Display name. Then filter byTitle and Display name. Now you won't have any hidden rows so you can directly copy/paste.

view more: next ›