Regulation catch, flew through some hands. :-)

RM.

The width seems borked on mobile – everything appears teeny tiny.

RM.

Murano Dark
RM.

Going by your description, are you using Power Automate desktop or the Automate feature in excel? I was more thinking of the cloud service (it used to be called MS Flow) for this, however… the cloud service would need access to one drive, your data warehouse and the SAS reporting service to do this. And, as pointed out  previously, the learning curve for Power Automate can be frustrating but once you get the knack of things it can be really useful. Perhaps a long term plan!

Good Luck with getting this sorted, things like this drive me mental at work!!

RM.

If someone were asking me to do this from scratch from what you’ve described (which I appreciate they aren’t in the case) I’d be looking at MS Power Automate to do this.

RM.

4 weeks here, but was told when ordering it could have been up to 6. The lad who delivered it said some folks take up to 9 months(!) but assume that’s ordered in.
RM.

Some great nostalgia on this thread.
Pigeon Street!
RM.

The wife?
RM.

I have tickets for Saturday and even with the 3 day results we’re seeing more regularly I thought the weather might guarantee some viewing but maybe not!

RM.

Shoes. Not the buying of, that war was lost eons ago – shoe choice is the current campaign. How is it possible to pick such inappropriate footwear so consistently?

RM.

Somewhere to start you off.. Check out the price of the Leeds to Dubrovnik flight with Tui tomorrow, returning following Thursday.

RM.

Looks like the bad actors have stoked up trouble. Desperately sad, all of it.

RM.

I think to do this, select the area (12 pixels or so will do) with a green grid and then say ‘enhance that for me’ there will then be a swooshy computer noise and the image will sharpen into 9k huuud. :-)

RM.

The 90s?

RM.

Is the reason we don’t have some new fangled phone/online voting ‘cos we’d then not have these action packed picture-in-picture scenes of the frantic counting folk of the north east trying to win a none-existent counting prize?
RM.

Balance things out by keeping some petrol, engine oil and screen wash in your bathroom cabinet.
RM.

The Olympics.

RM.

Scotland absolutely belting it round, shame there was only 10 overs of that!

Although covers coming back on at the break and some pretty serious clouds around, not even sure if we’ll get a result?

RM.

Round Ireland with a Fridge. Tony Hawks.

(Not history, but trust me on a good book)

+1. If you need some further light reading in the same vein, McCarthys Bar.

RM.

Despite my previous comment, I love a random guess. I’m nailing my flag to the Swiss! Go Nemo!

RM.

We joked at home during the semis that it would be the song with the most orifices would win. But then San Marino went out and our theory was shot! 😂

Loving the final, can’t guess a winner.

RM.

We need some sort of 3D Venn diagram thing that addresses the intersection of the toast cutters and the sit/stand bum wipers.

This is what AI thinks of this…

RM.

Netherlands for the win tonight from a totally barmy bunch! Loved it!

RM.

Where’s options 4 & 5??

RM.

To repel Deer, you need the opposite of Deer.

A sign saying ‘Best regards’ should sort you right out.

RM.

Ta, couldn’t remember the name! +1 from me too, had a fab night in there. To be honest, every time I’ve been out in Glasgow I’ve had a great time.

RM.

Howlin Wolf is my recommendation. Live blues music 7 nights a week.

Is this place in a basement / down from street level?

RM.

I’ve not got a dog (or child) in this race, but I’ve encountered more breaking of rule #1 from ‘regular punters’ in pubs than owners of dogs or kids. And I think you have probably too.

RM.

I’m not usually one for conspiracies, but this reeks of big farma sweeping stuff udder the carpet.

RM.

it appears that no one in this day and age seems to walk round their car before setting off occasionally.

The STW Road Captain™️ approved pre-driving checklist would be fun. 😃

RM.

Pinkster – I’d start by checking your data types are correct (dates are dates , numbers are whole/decimal etc.) and if you’re still struggling drop another screenshot on?

RM.

p.s. chatGPT is a pretty good tool for converting (or guiding) SQL to DAX.

It looks like you are not using any data for the x-axis, so it only has 1 point of reference so everything will be on that point. Is something along these lines your issue?

https://community.fabric.microsoft.com/t5/Desktop/Clustered-column-chart-without-X-axis-values/m-p/73643
RM.

Thanks for sharing the amazing times you’ve had with Fin over the years, always made me smile.
Hugs to all of your gang.

RM.

Back to PSR, looks like Leicester being dragged back into this by the Premier League after already being looked at by the EFL?

What a mess, especially a club looking like they’ll gain promotion and this saga won’t be resolved in time to have an effect on this season.

RM.

Did a fair chunk in the opposite direction in October 2015 – probably one of the best trips I’ve ever done. I thought it was very beautiful and the most authentic ‘French’ feeling holiday, if that makes sense. Stayed in b&b types of places. I’m sure you’ll love it.

RM.

Blackburn v Newcastle has been a good value as a neutral.
RM.

PowerQuery handles time, and tell you where you have errors – but it can be a little tricky to get used to.
If you want to use your existing data in Excel you’ll have to convert it to a table (select all – ctrl+t) and load the data from there (Data Ribbon – from table range).
Change the time column to the data type time, using the selector at the top left of the column.
I’d then add a conditional column, with 2 ifs: an if before 08:00:00 and if after 16:00:00 – both then 1, else 0.
Load these to a Pivot Table report and do a sum of the 1s from your new column by date and you’ll have your out of hours numbers.
If you want a count of both then use Day and Night instead of 1 and 0, and use these are your pivot table columns and count spec num as values.
RM.

Quite the night at Elland Road, always happy to get 3pts but man I’ve no clue how! Leicester had so many chances and were managing the game well, but seemed to completely lose the plot after we scored. I still think Leicester will win the league.
RM.

Ah @cougar I really miss your blue neon fish bowl.
RM.

Crazy stuff at the business end of the championship! Southampton losing again after their amazing run of form , Ipswich grabbing a winner after being hauled back to 3-3 in stoppage time. 2 pts and a little bit of goal difference between 2nd and 4th place.
All this before Leeds v Leicester on Friday night at Elland Road. Can’t wait!!
RM.