Jeff "Dash-bored" Weir
@insightsmachine
Looks like I picked the wrong week to give up sniffing Copilot
I was just gonna complain that you STILL couldn't expand the #PowerBI workspaces pane in order to see the full title of workspaces, but when I went there to take a screenshot for this complaint look what I saw! How long has that been there for? I like quality-of-life improvements. More please.
I take it the new #PowerBI "Sentence Template" tooltip syntax doesn't work on Table or Matrix visuals?
22 year old daughter is kinda disenchanted/disengaged and yet at the same time is reading this: “The righteous mind” by Jonathan Haidt
Blasting this album through these. Miracu-lege, not sacrilege.
“Can you pick up a packet of wafer-thin mints from the supermarket on your way home from your latest stereo pickups, monsieur?” “I’m absolutely stuffed!”
“Do you ever put your Stand-up desk in Sit-Down position?”
Here’s my current lounge setup: Tannoy Arden, KEF Reference 104/2, Linn Klimax Control pre and Linn Akkurate 4200 power, Michell Hydrolic Reference Turntable plus a Rotel RP-3000 with an SME 3009 on the other side, Quad 99 CD, WIIM Ultra Streamer, and most importantly an understanding wife.
...but rather you want to encase the coalesce stuff in brackets thus in order to get the desired result: = Table.AddColumn(#"Reordered Columns1", "Variance", each ([Component Amount]??0) - ([Prev Amount]??0) )
Interesting #PowerQuery learning today...if using the ?? Coalesce operator when subtracting two columns that may hold nulls, you DO NOT want to do this as per screenshot output: = Table.AddColumn(#"Reordered Columns1", "Variance", each [Component Amount]??0 - [Prev Amount]??0)
TL;DR “Where’s my umbrella?” “Why aren’t you singing?” “A *what* wedding?”
Oh cool…it’s the exact name I voted for in the national online poll! I’m gonna have a pint of Beery McBeerface to celebrate.
It looks like the files MUST be renamed. learn.microsoft.com/en-us/power-...
When I click on Combine Files nothing happens. When I click to the right of "Binary" under the Content I see this: Does that help?
Hey #PowerQuery peeps - I'm trying to do a Combine Binaries step on some .xslx files saved in SharePoint, but it turns out that some of them have "#" in the filename which is an illegal character in this context. I take it I have no option but to rename the files on SharePoint?
Still on winter holiday. Went to a couple of places I’ve never been before just North of Auckland: Scott’s Landing; and Omaha Beach (where I had a “refreshing” winter swim in 4pm’s waning sun. I know!)