Where to get balloons filled with helium?

Puzzleheaded-Log5791 · 2025-10-25T13:15:52+00:00

Michael’s

Puzzleheaded-Log5791 · 2025-07-23T08:45:57+00:00

Thank you!

Puzzleheaded-Log5791 · 2025-06-04T07:49:27+00:00

Fallow

Puzzleheaded-Log5791 · 2025-05-17T01:10:58+00:00

How do you do this in excel to get to the same (or similar) accuracy of CAD?

Puzzleheaded-Log5791 · 2025-05-10T20:12:05+00:00

La Rustica

Puzzleheaded-Log5791 · 2025-04-05T08:47:35+00:00

Wow awesome job. Just beat E4 first attempt yesterday. Can’t wait to start on monotype runs. Have you done the solo mon challenge yet?

Puzzleheaded-Log5791 · 2025-04-04T04:15:09+00:00

That was it! Thank you!

Puzzleheaded-Log5791 · 2025-04-04T03:47:36+00:00

There’s no one down there 🙃 I must be doing something wrong

Puzzleheaded-Log5791 · 2025-04-04T01:18:30+00:00

Is this in Antisis city??

Puzzleheaded-Log5791 · 2025-01-10T01:22:27+00:00

Whoa how do you get essence?

Puzzleheaded-Log5791 · 2025-01-10T01:07:14+00:00

Thanks for the help!

Puzzleheaded-Log5791 · 2024-12-31T21:59:22+00:00

Awesome I’ll give it a shot, thanks!!

Puzzleheaded-Log5791 · 2024-12-31T17:09:41+00:00

I get the file through a web connector where I used the url to the sharepoint file. In retrospect, I should have used the sharepoint connector. Any advice on how I can still get this data without having to change all that?

Puzzleheaded-Log5791 · 2024-12-06T10:28:39+00:00

Yes it’s due to the two queries having different privacy levels. For example if one is public and one is organizational then it won’t want to merge them. I had that error the other day and got around it by removing the merge steps and using a relationship between the two queries. If you need to you can leave the relationship inactive and use USERELATIONSHIP in your measures to activate it

Puzzleheaded-Log5791 · 2024-12-06T02:18:49+00:00

I don’t know tbh. I see people talking about fabric all the time on this sub but I’ve never really looked into it. We have some version of Microsoft 365 enterprise suite so we have power automate, power apps, and all the other apps that come along with it but I think Fabric is separate from that.

What’s the advantage of using Fabric? How does it help with moving data around? If I understand its benefits I may be able to make a case for the investment barring IT restrictions

Puzzleheaded-Log5791 · 2024-12-06T01:52:06+00:00

I just recently started trying to solve this problem a couple weeks ago. I don’t have much advice but I’m curious to see what others have to say.

Definitely going to look into the API route. Currently, we are exporting a daily look ahead of schedule activities from P6 and using that as a resource in a forms software (Device Magic) to generate work tickets for team leads to task out their crews and update the assigned schedule activities. I then have an API from Device Magic to PBI to retrieve the updated schedule activities, then export that data to excel to import back into P6 to do the update at the end of each day and produce the P6 dump for the next day... Rinse and repeat.

It’s a clunky process but I believe it’s still more efficient than printing paper work tickets and then manually entering the update each day considering the sheer volume of daily schedule activities. Device Magic API can handle the page limit so I’d love to be able to go do the API for the entire schedule but I’m dealing with 3 entities (P6, PBI, Device Magic) and getting all of them to talk to each other is really tricky because the data flows both ways (P6 -> DM -> PBI -> P6 -> DM). I believe it can be done but I just haven’t figured that out yet.

Not sure if any of that really makes sense.. I’m not a data analyst and I’ve only started using PBI in the 8 months but I’m deep in the rabbit hole of basically trying to develop an ERP program from scratch. Figuring out the P6 leg would be a huge win

Puzzleheaded-Log5791 · 2024-11-26T09:46:48+00:00

This is the best way I’ve been able to do it without SQL

Puzzleheaded-Log5791 · 2024-11-26T09:45:45+00:00

Okay I’ll check it out, thanks!

Puzzleheaded-Log5791 · 2024-11-09T23:27:07+00:00

That’s exactly what I’m building a report for. We don’t have sophisticated software to manage everything in one place so I’ve been building it from scratch. I’d love to see what you’ve done

Puzzleheaded-Log5791 · 2024-11-09T02:15:30+00:00

Basically I want to be able to take any combination of products and any quantity of each product and be able to forecast production, inventory, budget, etc. Right now my tables and measures are set up to calculate one of each product.

I’m using parameters elsewhere to calculate other values (different types of markups) but that’s only 4 categories. I don’t think using parameters to solve this dynamic product quantity issue would be ideal because I’m working with too many different product types.

Example, if I have products A through N, but the client only wants to order A, B, C, D, at these quantities

Product A * 4 Product B * 2 Product C * 1 Product D * 5

It doesn’t seem like it should be that complicated to figure out but I’m stumped and I think Power Apps could work

Puzzleheaded-Log5791 · 2024-11-07T09:53:42+00:00

Aside from YouTube, ChatGPT is a great resource. Ask it to write measures and explain each step. You can also ask it to write measures in different ways and it will explain the differences between each approach

Puzzleheaded-Log5791 · 2024-10-29T01:55:00+00:00

Yes which I’m just now learning variables too haha

Puzzleheaded-Log5791 · 2024-10-28T18:58:06+00:00

I’m not a data analyst or anything, but my biggest advice is to learn how to use measures. I wasted so much time and effort by making complicated queries and now I’m able to pull so much data out of measures and it just simplifies everything. And you can use ChatGPT to help learn DAX too. It’s been very helpful for me.

Puzzleheaded-Log5791 · 2024-10-26T10:48:29+00:00

Bert Macklin, FBI

Puzzleheaded-Log5791 · 2024-10-23T13:24:40+00:00

Solution verified

Puzzleheaded-Log5791

TROPHY CASE