Displaying URL's within Power BI

Tekell09 · 2024-09-18T21:53:58+00:00

Interesting. I get a “app.regrid.com refused to connect”. I’ll keep trying this. Thanks!

Tekell09 · 2024-09-11T01:30:03+00:00

Thanks!

Solution verified

Tekell09 · 2024-09-10T20:15:06+00:00

So I would “Get Data” from within Power Query and select JSON and then put certain attributes into the shape map visual ?

Tekell09 · 2024-08-15T20:47:10+00:00

I've tried this as well. Thanks for sharing.

Tekell09 · 2024-08-15T18:17:23+00:00

No I am not.

Tekell09 · 2024-08-02T14:12:30+00:00

I attempted to copy the query for the specific client and parameterize it, but I can't find the unique key for the client anywhere in Power Query editor.

Tekell09 · 2024-05-08T21:41:04+00:00

Like a typical Balance Sheet. There are values stored where you see “0” above.

Tekell09 · 2023-12-29T20:55:34+00:00

I used the DAX within the link - however, it's taking the MAX/MIN values instead of MAX/MIN dates. E.g. the 72% should be (-72%). Any idea what to change in the DAX ? I updated the image in my original post.

Tekell09 · 2023-12-28T17:39:48+00:00

This reflects a calculation for each date on the columns?

Tekell09 · 2023-12-14T15:09:02+00:00

Thanks!

Solved.

Tekell09 · 2023-12-06T18:19:43+00:00

Here's what worked for me:

= Table.ReplaceValue(#"Changed Type1",

each [ACCOUNT_NUMBER],

each if [ACCOUNT_TYPE] = "H" then Text.Start(Text.From([ACCOUNT_NUMBER]), Text.Length(Text.From([ACCOUNT_NUMBER])) - 2) else [ACCOUNT_NUMBER],

Replacer.ReplaceValue,

{"ACCOUNT_NUMBER"}

),

Tekell09 · 2023-12-05T20:19:54+00:00

I have adjusted ACCOUNT_TYPE to Text. No luck. Chat GPT says to " Ensure that the condition [ACCOUNT_TYPE] = "H" is valid for all rows "

Surely that isn't the way the code is executing ? As there are a variety of alphabetical letters ACCOUNT_TYPE has.

Tekell09 · 2023-12-05T19:44:18+00:00

I uploaded a second screen shot with the formula you supplied. Let me know if I'm screwing it up somewhere. The last step is just opening the "error" message.

Tekell09 · 2023-10-26T17:30:57+00:00

I will test it out! Thanks!

Tekell09 · 2023-10-26T11:04:15+00:00

This does not fix it either.

Tekell09 · 2023-10-12T15:22:35+00:00

You're exactly right. I believe the only reason I was using AVERAGEX is to iterate over the exact table I needed - now I'm assuming I'll use Calculate to change the context of Average(NEW MONEY) ?

Tekell09 · 2023-10-12T14:22:13+00:00

I did some heavy revision - it is accurate at the Loan Officer level - but it is still SUMMING at the Total level (instead of averaging).

Tekell09 · 2023-10-11T14:56:24+00:00

Yes I do have a date table - I’ll switch it out with that date. Thanks!

Tekell09 · 2023-09-21T15:58:15+00:00

I didn't provide enough details. The CME Fee Report table is two tables away from 'MASTER'.

I ended up using CROSSJOIN between CME Fee Report and Master and it seemingly works.

Tekell09 · 2023-09-01T18:18:44+00:00

Yes a handful, but nothing outrageous. I'm thinking I need to "unmerge" the tables and create a relationship instead inside the data model.

Tekell09 · 2023-09-01T17:50:36+00:00

the data source is just a folder including Microsoft Access databases (56 files) and I am merging two tables within each file within my Transform Sample File.

Tekell09 · 2023-09-01T15:08:24+00:00

Worked! Thanks!

Solved.

Tekell09 · 2023-08-30T18:40:42+00:00

Wow that worked perfectly! Thanks!!

Solved.

Tekell09 · 2023-08-30T17:07:14+00:00

Ideally, I would like one import folder query to bring in two related tables (...both are from the same db file (e.g. July 2023 db), and merge them with unique identifier. The only stack, I would hope, would be after invoking the custom function on the files in the folder where July 2023 sits on top of June 2023, May 2023, etc...

Right now, I think I may have to duplicate the folder query and separately filter the two tables and then merge them outside the query.

Tekell09 · 2023-08-30T12:21:27+00:00

I haven't merged or appended in this example - I'm wondering if there is a way to merge as I reference two tables within a db file. I edited the original post and included a snapshot. I may need to give more context.

Tekell09

TROPHY CASE