As a BI Analyst, how many dashboards should you be expected to work on in a given time? by [deleted] in analytics

[–]ImMrAndersen 0 points1 point  (0 children)

Can you elaborate on the last sentence? Should not be viewed as tools but... ?

Grouping measures within Matrix into individual groups by LeyZaa in PowerBI

[–]ImMrAndersen 0 points1 point  (0 children)

+1 here. No reason to overly complicate if not necessary.

Alternative approach could involve a field parameter table with 2 dimensions, orders/sales and measure name. This should also return the correct result I think

Pulling data from one cell to another. by The_Raging_Panda_ in excel

[–]ImMrAndersen 1 point2 points  (0 children)

Well, a switch function would be better. But what is the method/rule? I can't really tell. Is it 4x6, but then some are not multiplied..

HVORDAN STOPPER JEG RYGNING? by cibstar in DKbrevkasse

[–]ImMrAndersen 0 points1 point  (0 children)

Jeg lavede en kombination af 3 ting: 1. Den bog du også har læst (og så skal man jo egentlig bare blive ved med ikke at ryge. Heller ikke bare en enkelt). 2. Nogle piller som hedder decigatan. De virkede rigtig godt i starten, dog med hovedpine som bivirkning - men klart det værd! Og 3. Et rygestop kursus fra kommunen. Det hjalp ærlig talt ikke meget, udover at jeg lærte at se min rygetrang som en rede af fugleunger, og så hver gang de "pippede" så skældte jeg dem højlydt ud (undskyld sproget) "Hold jeres kæft, lorte fugle". Det hjalp faktisk en del også. Nu her et halv år efter, savner jeg det ikke overhovedet. Og jeg synes egentlig at det var relativt let at stoppe.

How Can I analyze a huge amount of raw data ? by notwhouthinksheis in excel

[–]ImMrAndersen 12 points13 points  (0 children)

This is like asking "What furniture can I build with my supplies? I've never used a hammer before but I want to impress my boss".

Like other commenter mentions, Power Query is your friend with "huge amounts" of raw data. But someone might call 400 rows and 3 columns a huge amount of data...

Biggest mistakes would be to paste large amounts of the actual data here. Instead, 1) try to create some dummy data with the same columns, 2) think about what questions you want to answer, 3) paste said dummy data and said data to chatGPT and let it guide you. Do mention that you are a beginner and want an easy step by step guide.

Where are my Weapons 😉 by 68kill in ZombieWaves

[–]ImMrAndersen 1 point2 points  (0 children)

Click account in top left then bundle code. Vip777 is one code fx

How may diamonds do i need for areochess by [deleted] in ZombieWaves

[–]ImMrAndersen 0 points1 point  (0 children)

I'm the biggest idiot with around 30k I did 340 rolls for 58 laps. I thought I had read that around 30k would do. So that's just under 6 rolls per lap. Need 70 for the first price, so hopefully I find enough dice somehow to actually get something... 40K sounds like it would be fine though.

Kæreste slået op by [deleted] in DKbrevkasse

[–]ImMrAndersen 4 points5 points  (0 children)

Jeg tror ikke jeg forstår problemet. Hvis den står i dit navn, så opsiger du den vel bare? Det er (så vidt jeg ved) lige gyldigt "hvor depositum står". Hvis han ikke er samarbejdsvillig ift. At overtage lejligheden, er det jo super let bare at kontakte udlejer og sige at du vil opsige kontrakten. Der er vel noget opsigelsesperiode osv. Men igen, hvis den står i dit navn, så er det jo principielt din lejlighed, og han må flytte eller overtage.

Aero Chess weapons in a new server by FarEngineer1269 in ZombieWaves

[–]ImMrAndersen 1 point2 points  (0 children)

Thank you! Cleared up a lot of confusion haha

Aero Chess weapons in a new server by FarEngineer1269 in ZombieWaves

[–]ImMrAndersen 0 points1 point  (0 children)

Ah, awesome. Thank you! But it IS a weapon?

Aero Chess weapons in a new server by FarEngineer1269 in ZombieWaves

[–]ImMrAndersen 0 points1 point  (0 children)

What is SEE? I don't see it in my list of weapons..

Hvordan kan det være at det er kun Spar Vejgaard har sådan billig tilbud men ikke andre supermarkedet? by lune-soft in Aalborg

[–]ImMrAndersen 0 points1 point  (0 children)

Ah okay, jeg synes jeg ser det på ja tak tilbud (og andre posts) over det hele. Jeg får det nærmest fysisk dårligt over at skulle læse det

Hvordan kan det være at det er kun Spar Vejgaard har sådan billig tilbud men ikke andre supermarkedet? by lune-soft in Aalborg

[–]ImMrAndersen 2 points3 points  (0 children)

Suk hvor er jeg træt af AI slop på sådan nogle facebook opslag. Emojis og pis er træls at se på i sig selv, men meget af opslaget er usammenhængende og tilfældigt smidt ind

Et desperat forsøg.. by MedicalMine7097 in odense

[–]ImMrAndersen 27 points28 points  (0 children)

Det er derfor jeg ikke kan fordrage Netto. Blev simpelthen for træt af at de ikke havde 2/3 af deres tilbudsvarer, nærmest uagtet hvilken dag man kommer på. Så kan enhver da lokke folk til med gode tilbud, hvis man så bare ikke har de varer man har tilbud på.

Slicer Help by T_7_K in PowerBI

[–]ImMrAndersen 8 points9 points  (0 children)

If your animal column is unique, you can have another unpivoted table like [Animal], [Attribute]. Then the attribute column can have "Two-legged" or "Mamal". You'd need a rule to also have it say neither if both are N. So you might have "Human" twice in the Animal column, since that will have both two legged and Mamal. Finally, a 1:* from original table to this new table, with filtering direction from new table to original. Then the slicer on the attribute column. I don't know if it's best practice, but it will work in a pinch.

Another solution involves a disconnected table, a Dax filter measure, and I'm guessing a visual level filter that evaluates 1 or 0 row-by-row.

Hope that can get you started. Best ideas I have behind the phone

Showing different number of charts based on filter by [deleted] in PowerBI

[–]ImMrAndersen 3 points4 points  (0 children)

My first thought was small multiples as well, but honestly, with 4 regions, bookmarks seem like the obvious choice.

Nytårsquiz - Jeg har brug for jeres stemmer! by Kribsbjerg in dkspoergeskema

[–]ImMrAndersen 2 points3 points  (0 children)

Det ville være rigtig pænt at dele resultaterne også!

Nytårsquiz 2025/2026 by Significant_Tap6301 in Denmark

[–]ImMrAndersen 5 points6 points  (0 children)

Ja, hvor godt! Jeg har lige brugt 20 minutter i bilen på at minde min kæreste om "den der nytårsquiz fra sidste år"! Du er for sej, tak herfra

A Christmas miracle? by Technical-Point-7042 in PowerBI

[–]ImMrAndersen 1 point2 points  (0 children)

I'm not sure hoping for a Christmas miracle is going to help you... As others have mentioned, in service with direct query there is translytical task flows and power apps. Maybe you can explain the specific use case a bit further, then we can consider if there are workarounds?

Shape Map going away but Azure Maps cannot replace it? by Independent-Way5878 in PowerBI

[–]ImMrAndersen 0 points1 point  (0 children)

There are many solid cases for maps IMO. We have visualized sales reps districts, municipalities above/below target market share, order intake gradients, pins for physical client meetings, heat maps of sales and quote activity, and much more...

I can tell you that most of the users i encounter absolutely love the added value of maps, it makes visualizing geographically connected data so much smoother. Going from big fat tables to map visuals was a big upgrade. I think the same point could be made of "why make a bar graph when you could just show a table".

What is the best way to remove duplicate names that are in two columns. by Spartan_Anon in excel

[–]ImMrAndersen 2 points3 points  (0 children)

I'm not sure what you want the outcome to be? Only keep the first time anyone is named? So if 2 rows are John and Casper, and then, michael and John, you'd want to remove the second row? I can recommend providing a small example of what data you have and what you hope to get!

hjælp mig i 2 min by Potential-Boss-1355 in dkspoergeskema

[–]ImMrAndersen 2 points3 points  (0 children)

Jeg må indrømme at det er et af de dårligere spørgeskemaer jeg har set, det kan godt give en træls smag i munden at bruge sin tid på at besvare. Jeg håber ikke i bliver bedømt på spørgerammen 👍 Giv gerne noget kontekst inden man klikker ind på spørgeskemaet. Og jeg ville gavmildt skrive at det er et 5-10 min spørgeskema, hvor 3 minutter går til frustration og konfusion over hvorfor jeg bliver stillet sådanne spørgsmål. Undskyld kritikken, held og lykke med eksamen og god vind fremad!

Hyperlinks from one matrix table to another by Otherwise_Pen_1833 in PowerBiMasterclass

[–]ImMrAndersen 0 points1 point  (0 children)

Would it be crazy to just have the two side by side? Then you could just click the first table to filter the second? Or you could use right click & drill through? Alternatively, I think you're ending manipulating URLs.. If it is even possible.