“Microsoft Digital Event” - Ilgar Zarbaliyev's Nuzzel Newsletter for Wed, Jul 1

This article is part of our back-to-basics blog series called what is…?, where we break down some common topics and questions posed to us. We've covered much of the content in previous posts, so this series allows us to bring together many…

A typical task when cleaning data is to extract substrings from string that follow a certain pattern. In this post I'm going to describe a method that uses the List.Accumulate function for it. Extract a pattern string. I have to extract a payroll…

I see a lot of Power BI datasets in the course of my work, and as a result I see a lot of datasets that look like this: What's wrong with this picture? Look at the names: The tables and columns have the same names that they had in the data source…

Sign up to our newsletter and claim your FREE copy of our eBook ‘Magic Tricks for Data Wizards'. In today's world, Data Preparation or Data Wrangling is not something that is only available by acquiring expensive and complicated software or…