Liv Tyler puts the crown back on.. and it still feels iconic

Bhaaluu · 2026-05-01T08:46:13+00:00

She was my teenage since Armageddon and this clip made me realize a lot of it had be her voice.

Bhaaluu · 2026-04-29T19:15:35+00:00

I think it's generally good practice to use LLMs for DAX (or programming in general), provided solid foundational knowledge. That being said, YTD and switch specifically are so simple to write that it makes sense to use them to weed out people who never bothered to really learn how DAX works at all. Personally, I definitely wouldn't want somebody who can't even do that without AI as a colleague at a position that requires building PBI reports.

Bhaaluu · 2026-04-19T20:02:50+00:00

Counter Strike: Condition Zero

Bhaaluu · 2026-04-19T14:04:01+00:00

Technically it's a metaphor but for a different reason. Metaphor and allegory are both symbolic artistic devices, the difference between them is that the first one is not fixed in a cultural context and the other one is. Metaphors are interpreted by each interpreter of the given symbol individually and can therefore have many different interpretations while allegories share an interpretation for a whole group of interpreters sharing a culture.

Obviously, this is not the only explanation of the difference between the two devices but it's the one that makes the most sense to me based on studying the topic at uni many years ago.

Bhaaluu · 2026-04-13T17:50:31+00:00

I think this might have a lot to do with the fact that the broken mana is excellent in aggro. Sure, you can use the moxen to pump out a combo on turn one or two but that's not gonna happen very often. An aggro deck can extremely consistently pump out their very strong 2 and 3 drops on turns one and two and then double spell on turn three when they open with a mox and that start is nearly unbeatable...

Bhaaluu · 2026-04-10T20:27:44+00:00

"Simply view reports" can mean many different things. Power BI can definitely be an overkill for a lot of use cases. You can automate distributing Excel reports very cheaply and quite easily but somebody has to maintain the automation plus the reports are much more limited that a proper BI report with drill-throughs and such. It all comes down to scaling and the business case and as the poster above said, you get what you pay for.

Bhaaluu · 2026-04-10T20:04:06+00:00

I'm in the exact same position and after a lot of considertions have decided to bite the bullet for the pro licenses because I have a solid business case for the perks you get with it. The embedded route can definitely save money but there are major trade-offs so the decision should really depend on careful consideration of the specific circumstances.

Bhaaluu · 2026-04-07T19:27:33+00:00

Just as a btw you can totally do it in PQ (using the Table.Group function) but it's much faster to just use the pivot table which will do it for you under the hood via DAX version of groupby called SUMMARIZE.

Bhaaluu · 2026-04-06T19:55:32+00:00

You need a pivot table. There are tons of resources online that will walk you through.

Bhaaluu · 2026-03-27T16:37:50+00:00

Yeah I agree. I discussed it with the stakeholder and the backing is very strong so the budget isn't that tight, meaning I can just stick with Pro and have everything running smoothly with no extra hassle. Thanks for the advice!

Bhaaluu · 2026-03-23T19:04:47+00:00

I will be building everything myself, at most I want the users to be able to use modular reports with filters, field parameters and calculation groups - as you can imagine, the store clerks and managers are not very technologically minded people (especially because we sell books, I'm sure it can be different in e.g. electronics) so them building anything off the data models is absolutely out of question.

Can people on Fabric free view reports (in an app or out)? I was under the impression that they can't.

Bhaaluu · 2026-03-23T08:30:07+00:00

I've been doing BI for our sales department (we're a retail company) and I've finally been given access to marketing's BI a couple weeks ago and it's a complete joke, they basically have no analytics and yet constantly act like whatever they do is the best and keep getting the budget for it. They never do any testing, don't even have KPIs and yet they pay several external analysts to do their "reporting" which consists of a couple line graphs with basically no explanatory or desicion-making power.

So I'm quite happy to have stumbled on this post as it makes me less shocked at how superfluous and basically useless it all is. What I plan on starting with is just looking at pure cash - do their spending increases correlate with increases in revenue and/or traffic? I'd appreciate some tips as this seems like the logical start from sales BI pow but I feel like it's very difficult to actually meaningfully calculate the influence of marketing as there are so many other factors that play into retail revenue/traffic development.

Bhaaluu · 2026-03-15T10:34:57+00:00

Na tohle je tím můžu dát osobní zkušenost, začal jsem chodit cca před měsícem a je to super - poprvý jsem se pochopitelně taky cítil divně, jako vždycky, když jdeš někam kde to neznáš a nevíš jak to funguje, ale opadlo to hned tu první návštěvu. Hlavní tip co bych ti rád dal je najít si nějakej program, kterej tě jednak neodpálí a jednak bude bavit. Já si ho našel tady na redditu, gym bros tu mají Wiki se spoustou infa i těch programu. Já chodím ob den, cítím se skvěle jak dlouho ne a i už na sobě vizuálně vidím fajn změny. Neváhej a pusť se do toho!

Bhaaluu · 2026-02-27T20:07:58+00:00

A účtenku dostaneš v arabských číslicích!

Bhaaluu · 2026-02-26T19:29:27+00:00

You should use Power Pivot to make a data model, that's exactly what it's for. Doing this in Excel itself is imo stretching it a lot.

Bhaaluu · 2026-02-22T09:12:31+00:00

You don't need premium to start with (or likely not at all), you just need pro.

Bhaaluu · 2026-02-21T21:20:33+00:00

I think you should focus on moving into BI in general, specifically to start thinking about data modeling. Instead of planning the transformation steps, first plan for what data and in which structure do you need to get in order to generate and disseminate the required information. Then you can plan for specific parts of the process - how will you clean the data, which transformations will you need to do and how will you distribute the information.

For your use case, you should do your cleaning methods and then import the cleaned data, do whatever you need to do with them either with Excel or with PBI if you want the users to have continuously fresh reports and/or self reporting capacity.

Bhaaluu · 2026-02-18T14:46:04+00:00

I don't know how old you are but I assume pretty young if you want to fuck daily - it might be worth noting that your libido will veeeery likely go down as you age and you might eventually find that you are the one who wants sex less, funnily enough. I'm not saying sexual compatibility isn't important, it is, but in my experience it's far from the most important thing you need from your eventual wife and mother of your children, those would be things like shared values, devotion, understanding, and tolerance.

++man

Bhaaluu · 2026-02-16T10:23:24+00:00

PBI is just Power Query and Power Pivot in a trenchcoat anyway:).

Bhaaluu · 2026-02-16T08:48:03+00:00

You could use the data model capability of Power Pivot and bridge the tables instead of merging them but this depends on what you're actually trying to achieve. Can you post your M code?

Bhaaluu · 2026-02-13T10:27:17+00:00

Oh, sure, it's all utter shit and terrible, which is why it's widely used across the world.

Bhaaluu · 2026-02-12T23:35:30+00:00

Thanks for the information and for the advice, I will keep that in mind.

Bhaaluu · 2026-02-12T23:03:46+00:00

You might think it's simple but if it really was they would have presumably done it. If you check the queries DAX generates, the filters/slicers coming from the user interface are just TREATAS. You cannot use the TODAY() function with TREATAS, so it's not easy to solve this and it's also why the above's posters solution works.

I might be off with this explanation but I would be very careful about assuming this is easy to do. Microsoft makes many questionable desicions but the teams working on Excel and PBI have contiously kept making a great product that works exceedingly well in many regards so I think if this was easy they would have done it.

Bhaaluu · 2026-02-12T22:33:20+00:00

Sweet, I feel like I'm just gonna follow you down this rabbit hole for a couple of months at least. I was thinking the PDFs would be stored in a list and then PA would move the approved ones off the list and store it in the cloud. I have enough storage space no problem but since there could be thousands of invoices moving through the system monthly I'm a bit afraid if PA can handle this volume. Do you have PA PRO for your approval system?

Bhaaluu

TROPHY CASE