Custom Column Transformations in Power Query
Applying standard transformations to several columns at once is a snap in Power Query. Select all the columns, right click on them, go to transform and pick your pleasure. Boom,
Stay up-to-date with the latest customer data news, expert guidance, and resources.
Applying standard transformations to several columns at once is a snap in Power Query. Select all the columns, right click on them, go to transform and pick your pleasure. Boom,
Most people are aware that Power Query lets you work with tables that have columns containing other “inner” tables. The classic example is a table representing an Excel workbook where
The addition of the R statistic engine/language to the Power BI platform presents a lot of possibilities for both getting new kinds of data into your model, and displaying information
This is a cool trick that goes hand in hand with Relative Month Index. It shows how to include a slicer that lets the user choose which month they want
–VIDEO TRANSCRIPT– In this video I’ll demonstrate how to set default values for function parameters. Some programming languages let you define a function with default parameter values like this: public
One of the nice features of Power BI is the ability to select slicer configurations in design mode which are then exposed to the user once they open the report.
If you want to understand DAX, sooner or later you’re going to have to deep dive into Table Functions. The SQL BI guys Marco Russo and Alberto Ferrari train people in Table
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.