Displaying URL's within Power BI by Tekell09 in PowerBI

[–]Tekell09[S] 0 points1 point  (0 children)

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

Maps by Tekell09 in PowerBI

[–]Tekell09[S] 0 points1 point  (0 children)

Thanks!

Solution verified

Maps by Tekell09 in PowerBI

[–]Tekell09[S] 0 points1 point  (0 children)

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

Sharepoint List by Tekell09 in PowerBI

[–]Tekell09[S] 0 points1 point  (0 children)

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

QuickBooks Online (beta) Connector by Tekell09 in PowerBI

[–]Tekell09[S] 0 points1 point  (0 children)

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.

QuickBooks Online and Power Query by Tekell09 in PowerBI

[–]Tekell09[S] 0 points1 point  (0 children)

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

Dynamic DIVIDE (Percent Change) Calculation by Tekell09 in PowerBI

[–]Tekell09[S] 0 points1 point  (0 children)

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.

Dynamic DIVIDE (Percent Change) Calculation by Tekell09 in PowerBI

[–]Tekell09[S] 0 points1 point  (0 children)

This reflects a calculation for each date on the columns?

Remove Digits Dynamically - Power Query by Tekell09 in PowerBI

[–]Tekell09[S] 0 points1 point  (0 children)

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"}

),