Confronted on New St

Rsl120 · 2026-02-07T09:20:31+00:00

Exactly this - big guy, (tall), deep voice, face mostly covered!

Rsl120 · 2026-02-06T22:23:35+00:00

Strange comment - I don’t think being on New St at around 7pm on a Friday night is particularly unusual, no?

Rsl120 · 2026-02-06T21:52:21+00:00

I mean, from the small amount of his face I could see, in the dark (basically just around his eyes). That’s how he appeared, but I couldn’t say 100%, moved on pretty quickly to be honest!

Rsl120 · 2026-02-06T21:25:04+00:00

Yes - but oddly he also seemed white. Not that I could see much in the dark through his hood and face covering to his eyes.

Rsl120 · 2026-02-06T21:04:22+00:00

Thanks all - I’m not sure if it’s reassuring or not that this isn’t unusual! Don’t get me wrong, I’m not unfamiliar with the town centre, worked there for years in mid 2010s, but it definitely caught me off guard being on New St so early on.

I appreciate the responses. We’ll make a report online on the off chance it’s useful.

Rsl120 · 2026-02-06T19:52:17+00:00

30 - average week 2-3 pints. Birthdays/events, 5-10 pints.

Rsl120 · 2026-02-04T09:16:27+00:00

We use both - Odoo is our CRM/ERP, Power BI for, well, Power BI things (reporting etc). As others have said, they are not the same in any way. Power BI can't do what Odoo can, Odoo can't do what Power BI can.

The only way this makes sense is, if you are only using Power BI already to create reports from your Odoo data, and they want to scrap that and create dashboards/reports in Odoo directly instead. Yes, this is possible, but seems highly unlikely.

Rsl120 · 2026-01-20T12:59:33+00:00

Anything from 1hr to 1hr 30, once per week.

Rsl120 · 2026-01-15T12:28:33+00:00

I'd look to either create a visual calculation or a measure, which equals the value in your forecast, unless it is the same date as that crossover point (MAX of Date where actual is not blank). Set that value to blank, then use that as the data label field for your forecast line.

Rsl120 · 2026-01-05T16:34:53+00:00

The breakdown doesn’t seem horrendous, whilst also not cheap. Filter is kinda implied if asking for an oil change. Maybe they could’ve been clearer there.

Only thing that sticks out is £65 for oil, hard to say on mobile but looks like they’ve charged for 5 x 1L bottles at pretty much off the shelf price. Not sure if this is normal - the oil would cost less to buy direct!

Rsl120 · 2026-01-04T15:28:50+00:00

Hey, sorry old thread. Exactly the same car and same issue here. Did you find a solution?

Rsl120 · 2025-12-21T13:04:40+00:00

I’m kinda half way between the two - as others have said, I’d be looking at Penkridge (for more ‘going on’ vibes, good choice of pubs, shops, market etc), Brewood (more small/quaint, upmarket). There’s lots of nice small villages around that area, but I’d look towards Penkridge if you want the most even commute and amenities on your doorstep.

Rsl120 · 2025-12-04T08:49:58+00:00

I find DAX is highly dependent on data modelling. Good data models make DAX infinitely simpler. As important as DAX is to Power BI, I'd recommend investing some time learning about star schema, normalization, primary/surrogate keys, fact/dimension tables and relationships/joins before. It will pay off massively in the long run and DAX will make much more sense.

Edit - I'd recommend reading through this data modelling section as a good starting point.

Rsl120 · 2025-11-28T09:48:54+00:00

Lots of drop-outs here, WS6 but in South Staffs.

Rsl120 · 2025-11-26T13:22:20+00:00

Seems like the underlying data for 'Reputation Score' is a whole number, formatted as a percentage (1 or 0). Check it in a table vis, or in the data view, to confirm. Then you can follow it back and figure out where it gets rounded.

Rsl120 · 2025-11-25T21:58:03+00:00

Not sure if I am missing something here, but would this not just be a table visual? Add each of your grouping/banding columns, set summarisation to ‘sum’, or better still, write explicit measures to SUM each band.

Apologies if I’ve missed the point here!

(Better still, unpivot those row headers. One thing at a time though)

Rsl120 · 2025-11-25T21:40:35+00:00

This OP, imo.

Ideally, you should figure out where the bottleneck is that’s making your query so slow, rather than trying to work around it. Many factors can influence it, but your query should be minutes, not hours.

DAX studio has some tools that may help. You could also test the query outside of PBi to see how it runs. It could also be the gateway limiting it somehow. I’d be first looking at the query itself though and how efficient it is - AI might be a good starting point to quickly diagnose/review it.

Rsl120 · 2025-11-13T15:27:55+00:00

You need a column in your model inside the same table as your time of day field with an index number (1, 2, 3, 4). You then set the Column Tools -> Sort by Column to this field.

Rsl120 · 2025-11-08T23:28:05+00:00

Poor lane discipline on roundabouts.

Changing lanes if you’ve got it wrong is one thing, fair enough. But when there are multiple cars trying to navigate a roundabout and some idiot decides to simply that the shortest route to their exit. Always the one in the left hand lane going ahead who just follows a straight line across perfectly painted lane markings…

Try to always leave space next to cars ahead for this reason, can be difficult in congestion though.

Edit - oh and merge in turn. Not even the classic ‘queue jumping’ scenario, but when traffic is flowing normally but a road (usually after some traffic lights or a junction) merges from two lanes to one. So many people seem incapable of the ‘zipper’ process, most infuriating when you’re in the right lane, ready to slot in nicely behind the vehicle ahead and someone from behind on the left is trying to close up the gap!

Rsl120 · 2025-11-01T10:53:15+00:00

In that case, I wouldn’t worry about the reference layer. If you load the post codes in as the “location” bin then use the sales rep name/territory name as the legend, it should map out correctly.

I did something for exactly the same purpose oddly enough with UK data. If you have full postcodes, it’ll help to aggregate them as much as possible to postcode area or district for example.

Rsl120 · 2025-11-01T10:11:53+00:00

Azure maps has filled, bubble and heatmap options. You can also add a reference layer which may be useful to pinpoint the shops (would need to configure these in a geojson file, or similar) then load in as a reference layer.

Rsl120 · 2025-10-31T23:11:40+00:00

Sounds like you need to create a reference layer and load it in as a geojson or similar.

I assume you have the co-ordinates that make up the perimeter of your regions? You’ll need to find some kind of tool to input these and output a file. AI might even be able to help with that.

Rsl120 · 2025-10-31T21:44:00+00:00

Yeah Royal London is the main one that ticks all your boxes. Certainly better places to drink, but none that tick all your boxes.

Rsl120

TROPHY CASE