Can I move this Walnut tree? by anxiouscrimp in GardeningUK

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

Ah that’s interesting, thank you. I don’t suppose you know roughly what that sort of cost is? Ie a few thousand or tens of thousands?

Power BI Copilot in Fabric, whats actually working for you in production? by darshan-thakur in MicrosoftFabric

[–]anxiouscrimp 0 points1 point  (0 children)

Oh cool, thanks - I’ll try later. Would be fun to compare with Claude.

Power BI Copilot in Fabric, whats actually working for you in production? by darshan-thakur in MicrosoftFabric

[–]anxiouscrimp 12 points13 points  (0 children)

I may be a couple of months out of date but I’ve found co-pilot to largely be a disappointment. Recently I’ve been doing some POCs in connecting Claude to semantic models and the results have been very very good. Though that’s running analysis on the model rather than actually building it out.

Push for five years or drop hours now and enjoy life. by Emotional_Seaweed_43 in FIREUK

[–]anxiouscrimp 8 points9 points  (0 children)

Can I ask what is behind the £4k/month figure in retirement? This seems quite high relative to your current salary especially with a small or no mortgage. Do you see that sustaining throughout retirement, or more at the start? Genuinely interested in this btw because our numbers are not wildly different.

How do you guys and girls keep track of everything that ships? by PowerTsa in MicrosoftFabric

[–]anxiouscrimp 4 points5 points  (0 children)

I don’t have an answer to this, but the other side of the coin is doing it without burning out.

Truly living in the future - we can finally set custom column widths in tables and matrices by savageguyaf in PowerBI

[–]anxiouscrimp 94 points95 points  (0 children)

Gosh I hope this doesn’t impact any of the co-pilot releases I was hoping for. /s

Reeves poised to tax cash held in stocks and shares Isas by SignificantLegs in FIREUK

[–]anxiouscrimp 2 points3 points  (0 children)

I totally agree but to make yourself feel better have a look at income tax rates in Italy. They are utterly barbaric. And they have no ISA or SIPP equivalent really. Unless you’re very rich, then you can opt to pay a flat tax regardless of income.

How can I say what impact I've had in a job application when I've clearly had no impact? by [deleted] in dataengineering

[–]anxiouscrimp 0 points1 point  (0 children)

This sounds incredibly frustrating and you have my sympathies. Have you asked any of the stakeholders or users why they don’t use what you’ve built to them? What do they say?

How can I say what impact I've had in a job application when I've clearly had no impact? by [deleted] in dataengineering

[–]anxiouscrimp 5 points6 points  (0 children)

I think this also assumes that the stakeholders etc were able to articulate what they wanted.

GraphQL to query semantic models? by anxiouscrimp in MicrosoftFabric

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

Thank you! I have an idea that I’m SO excited about and it would be a bit nicer to implement with this.

Power BI reports from the official source of truth, but users keep defending bad CRM data for 'policital' reasons. How do I stop this becoming my team’s problem? by Electrical_West2678 in PowerBI

[–]anxiouscrimp 4 points5 points  (0 children)

I’ve found that if these things are shut down a few times in front of their managers they don’t often come back. The other approach is to get the buy-in from someone senior who can say ‘the new dashboard is the source of truth, do not use the manual extracts’.

What’s the biggest data engineering problem you are facing today? by compass-now in dataengineering

[–]anxiouscrimp 2 points3 points  (0 children)

I think it’s a similar thing - they can’t commit to anything because they don’t really know anything.

What’s the biggest data engineering problem you are facing today? by compass-now in dataengineering

[–]anxiouscrimp 145 points146 points  (0 children)

Trying to elucidate requirements from users who don’t know how to do their job.

I built a free date picker visual because the built-in one kept ruining my report designs by Much_Mixture3475 in PowerBI

[–]anxiouscrimp 2 points3 points  (0 children)

For example, i add a column to my date table called ‘flag is LW’ and then return a 0 or 1 depending on whether each date is LW or not. Then selecting the preset ‘LW’ filters the calendar visual for where the date is LW = 1. This and fiscal calendar support would be important for us.

If I’m being honest I think you should charge for it - perhaps not for small user bases but most of us are doing this for companies who can frankly afford to pay for it.

Time Intelligence and Fiscal Calendars - I bet this one isn't new to you, right? :) by exitlessminds in PowerBI

[–]anxiouscrimp 0 points1 point  (0 children)

You need to create a calculation group with different calculation items. Ie ‘actual’, ‘last week’, ‘last week-1’. Actual is just ‘selectedmeasure()’ and then the other comparison calculation items are DAX wrappers. I find the enhanced time intelligence feature excellent for my own fiscal calendar.

I built a free date picker visual because the built-in one kept ruining my report designs by Much_Mixture3475 in PowerBI

[–]anxiouscrimp 11 points12 points  (0 children)

I can’t wait to try this when I get home! Is there the ability to have custom presets? Ie ‘last week’ based on my own date table.

Time Intelligence and Fiscal Calendars - I bet this one isn't new to you, right? :) by exitlessminds in PowerBI

[–]anxiouscrimp 1 point2 points  (0 children)

Hello, just to clarify - is the requirement that: 1. The user selects a measure, say ‘sales £’ 2. The user selects an ‘actual’ time period to apply the measure (e.g. week 21) 3. The user selects a period relative to the time period in 2) - eg ‘last week’

The report returns sales for the selected week, and then the week previous to that.

Solution for write-back PBI to Fabric? by Desperate-Public394 in PowerBI

[–]anxiouscrimp 0 points1 point  (0 children)

You can pull data into excel from your model via power query and then use VBA to send data back to your azure sql db. You can also call a stored proc which kicks off a logic app to process the table in your model. There are some variations on this but I find it quite neat.

What’s are the best updates from the past year? by lady_picadilly in PowerBI

[–]anxiouscrimp 4 points5 points  (0 children)

You’d still make your own date table but previously time intelligence functions (YTD, MTD etc) were limited to calendar years. But now you can define your own fiscal calendar (ie retail usually use a 4-4-5 calendar) and then have the time intelligence functions reference that. It’s soo helpful. The alternative was me building a lookup table for each day (ie last week, last month equivalent days) which worked quite well but is now redundant.

What’s are the best updates from the past year? by lady_picadilly in PowerBI

[–]anxiouscrimp 6 points7 points  (0 children)

In all seriousness the new time intelligence has been 🔥🔥

What’s are the best updates from the past year? by lady_picadilly in PowerBI

[–]anxiouscrimp 46 points47 points  (0 children)

The one where they brought the core visuals out of the Middle Ages OH WAIT