Hello, data lovers! I was studying temporal decomposition in data science and I find the concept very useful for many applications in Power BI. However I know that many small
The Definitive Guide for Chart of Accounts in PBIThe Definitive Guide for Chart of Accounts in PBI
In this post, we are checking the method that I created to generate a proper dimension for BI base in a chart of accounts from a company. Video Explanation tl;dv
Group by when the order is importantGroup by when the order is important
Hi guys, in this video we gonna see how to use the parameter GroupKind.Local in the function Table.Group. Our goal today is to transform the List of Naruto episodes on
Migrating payroll with PowerQueryMigrating payroll with PowerQuery
In this video, I explain how is possible to simplify the migration of a Payroll by only 2 Form-To instead of 15.
Merge with partial matchMerge with partial match
In this video I show how to make a Merge with partial match in PQ. Function Code let Source = (Text as text) => let Source = FromTo, #"Replaced Value"
Get M! Avoing API LimitsGet M! Avoing API Limits
Hi Bi community. Before Start with the publications I would like to explain the goal with “Get M!” posts. For this category, I’ll focus exclusive in M language, no beautiful
Starting with SSDTStarting with SSDT
Installing SSDT