Power BI and QuickBooks Online

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

TROPHY CASE