Winston Snyder

#excel | #customnumberformats I was today years old when I learned you could use an index number inside a custom number format string in Excel. See Color48 below to return a gray zero. _(* #,##0_);_(* (#,##0);[Color48]_(* "-"_);_(@_) #microsoft #micros…lnkd.in/g6VBUuAP

Excel Error Austria Vote Interesting. When you pound a nail with a hammer and you accidentally miss and hit your thumb, who is to blame - the hammer or the user? Exact same thing in the case of this vote in Austria. Double-check y…lnkd.in/gDARv5dr lnkd.in/geR3dZQu

Love this one today from ChartR/Storytelling Note the broken y-axis between 0 and 1:45. This helps visualize the change in the average length of a baseball game. What can MLB do to make it even faster? 1:54 minutes sounds good to me. We dropped 2 of 3…lnkd.in/gdhE96ww

Aging Population Crazy this one from Visual Capitalist By 2100, 25% of the world's population will be 65 years old or older. lnkd.in/gthKNQ8h

#Fabric | #Powerbi Is it just me, or does the color of the new #logo for #Fabric look the same color as rebranded #PowerBI desktop? #microsoft lnkd.in/gg6KzuZ8

Excel | Toolbar Two kinds of Excel people in this world. New Toolbar View or Classic View. Which are you? I'm using Beta Channel version of Excel so you may not have features if you are on another channel. #microsoft #office365 #excel lnkd.in/g53Y8yx5

Power BI | Subtitles Power BI Desktop now supports Subtitles with March 2023 release. Lot's more goodness to unpack. Great job Power BI Team! #microsoft #powerbi lnkd.in/g6c9piPR

Excel | Slicers | Search Nice trick here from Jon Acampora at Excel Campus how to "add" search to your Slicers in Excel. Link in the comments. #microsoft #excel #slicer lnkd.in/gegYBx7W

Test – please ignore. But if you don’t want to, I created the bold text by creating in Word, applying formatting, copy/paste to LinkedIn. #linkedin #lackofformattingoptions

Power BI | DAX | Time Intelligence I know how he feels. I was was working with STARTOFQUARTER() yesterday #microsoft #powerbi #dax #timeintelligence lnkd.in/g87smmUd

Power BI | Data View It would be helpful if we could Filter on Selected Item as we can in Excel #microsoft #powerbi

I don't like the new Microsoft 365 App logo. Put me down for a no. #microsoft #office365 #microsoft365 lnkd.in/gpBbitbR

Power Query | Power BI | Excel When you add a random number to a Custom Column in Power Query using Number.Rand() or Number.Randbetween, you have to add an Index Column before and after the Rand Column. Why is that? #microsoft #powerquery #excel #powerb lnkd.in/gSNkb-42

Power BI | Datasets | Excel Tables You can now analyze Power BI datasets in Excel using Excel Tables, not just Pivot Tables. Not a big one for me - I'm ok using Pivot Tables. Will you use this feature? Will this drive adoption of Excel Tables? Link to…lnkd.in/gSfPHPPe

Excel | Inquire | COM Add-in If you are using Office Professional Plus or Microsoft 365 Apps for Enterprise, make sure you take a look at the COM Add-In "Inquire". It has several features, the best of which (to my way of thinking) is the ability to comp…lnkd.in/gy3yTY2R

Excel | Power Query |If..Then..Else I want to create my own If..Then..Else in Power Query. I don't want to use a Conditional Column. It's a bit difficult - isn't it? It feels as though this could be easier. I've taken to typing it into Notepad++, copy,…lnkd.in/gApbAMDv

Excel Office Scripts What do we have here? Recording Office Scripts is now available in Excel for Windows (Beta Channel) Next step will be integration with VSCode which is already available in Excel for the Web. lnkd.in/gqKVnXyF

SQL Server | TSQL I see many mentions for postgresql and mysql - but not so much for SQL Server. Why is that? Did you know, you can download/install SQL Server Developer for free? 🟩Free! 🟩Yes, I said free What's more, Microsoft provides many databas…lnkd.in/g66a4TSw

#excel #powerpivot Trying to create a calculated column in Power Pivot is not good. Much easier in Power BI. If I try to add a parenthesis or a comma, sometimes the entire formula is removed, and I am left with just the last character I typed. Anyone else similar experience?