Removing Excess Spaces Between Words AKA Inner Trim (Power BI)
Text.Trim() does an excellent job of getting rid of things like ” leading spaces” and “trailing spaces ” but unlike its’ Excel cousin it doesn’t handle “excess inner spaces” at
Stay up-to-date with the latest customer data news, expert guidance, and resources.
Text.Trim() does an excellent job of getting rid of things like ” leading spaces” and “trailing spaces ” but unlike its’ Excel cousin it doesn’t handle “excess inner spaces” at
Line charts are the ideal way to show historical data when ‘understanding the trend or path of a metric’ is what your decision maker is after. Like most good visualizations
If you’re used to working in Excel you’re quite familiar with the idea that there’s about a dozen ways to do anything. In this video we look at yet another
The art of visualization layout is a tricky one. Once you start throwing more than one or two charts onto a page it can start to turn into a tricky-to-navigate
Relative Month and Year columns in calendar tables are indispensable. They let you create simple, easy to read time intelligence measures that don’t require recoding at the end of each
(AKA “Pleased to Meet You, I Hope You Guess My CSVs Name.”) This is based on a question that floated into my inbox this week. If you’re combining a folder
Month label columns are invaluable for things like slicers and report axis. When users see 9 then don’t immediately get that you’re talking about September, but put a “Sep” on
List.Zip() is a strange function. It takes a list of lists, and returns a list of lists; so it sounds like it might not do anything. But to the contrary,
Say a customer wants a line chart with a sales line, a 3 month moving avg, a 6 month moving avg, a 12 month moving average, and a same period
Some developers rely heavily on intelligent code completion for their development workflow. If you’re developing outside of a powerful IDE like Visual Studio, you may only be aware of “smart” code completion.
Industry leaders and over 6 million end users choose Skypoint as their comprehensive and compliant Modern Data Stack Platform. A Gold Certified Microsoft Partner, Skypoint Cloud turns siloed customer data into connected customer experiences.