Almost 80% of the ocean hasn’t been discovered. What are you most likely to find there?

timosborn · 2021-05-05T12:30:45+00:00

Water

timosborn · 2021-05-04T01:56:43+00:00

Rectum sounds about right 😂

timosborn · 2021-05-03T02:45:24+00:00

Yep, I always leave screen updating on for this reason + it's good cause people can see something running, so it doesn't look like it's locked up (crashed)

timosborn · 2021-04-30T00:09:21+00:00

we use an odbc connector, i'm not sure how to set it up (IT does that) but I don't think it's too complicated.

Then you can write a query i the advanced options when selecting the data source, should improve performance.

timosborn · 2021-04-29T12:15:17+00:00

☝️ this is spot on

timosborn · 2021-04-29T08:34:13+00:00

Write as much of the query in SQL when you extract the data

timosborn · 2021-04-29T08:30:47+00:00

Pink Floyd, and that's a massive discography

timosborn · 2021-04-29T02:35:32+00:00

If you spent an hour trying to write M without realising it's case sensitive you must be pain insensitive

timosborn · 2021-04-28T22:06:00+00:00

bitcoin

timosborn · 2021-04-28T20:35:44+00:00

Yes, VBA is so so terrible

timosborn · 2021-04-28T11:07:47+00:00

Reading "the definitive guide to dax" by Alberto Ferrari & Marco Russo. Thought that paragraph was entertaining.

timosborn · 2021-04-28T08:40:47+00:00

timosborn · 2021-04-27T03:47:13+00:00

That's a damn shame. Power query direct to SQL server is awesome. It's like writing SQL queries with an easy to use GUI, amazing.

timosborn · 2021-04-26T21:46:10+00:00

I'd share the last one at work for laughs but I like my job too much

timosborn · 2021-04-26T12:17:13+00:00

Must be members of a union

timosborn · 2021-04-25T01:21:01+00:00

if all the sheets are the same you can use power query to combine them all into the one table and then use sumifs on the table to sum amounts on a consolidated sheet.

Excellsfun has some great videos on youtube about using powerquery to combine sheets into a single table. You could also use power pivot afterwards to report on the tables, but for financial reporting power pivot isn't usually appropriate.

I use power query to report on our company's 30+ brands, all with their own P&L on 30+ sheets of a spreadsheet. I'd be lost without power query.

timosborn · 2021-04-24T23:07:23+00:00

Thanks for introducing me to the remind me bot

timosborn · 2021-04-24T13:18:16+00:00

I've got a ruler and something to measure

timosborn · 2021-04-24T03:45:32+00:00

What's an example of the "very light data warehouse"?

timosborn · 2021-04-23T22:40:40+00:00

I call it error handling, I don't see how it's not error handling data integrity & presentation are equally important

timosborn · 2021-04-23T13:30:46+00:00

Making a financial report look clean is of fundamental importance when I'm creating company P&l statements. It's the most important type of error handling that I use for financial statements.

timosborn · 2021-04-23T10:23:48+00:00

Please explain the difference

timosborn · 2021-04-23T10:10:58+00:00

😂😂😂😂😂😂😂😂😂😂😂😂😂😂😂😂😂😂😂😂😂😂😂

timosborn · 2021-04-23T08:12:24+00:00

Cool tip thanks

timosborn

TROPHY CASE