Multiple replacements in a Column using Power Query
Record.FieldOrDefault (official documentation here) is a seldom-used function in Power Query. But here is one handy use of this formula[…]
Read moreCategory: Power Query
Replicating PATH function of DAX in Power Query / M
DAX provides five functions (PATH,PATHLENGTH,PATHITEM,PATHITEMREVERSE,PATHCONTAINS) to help users manage data that is presented as a parent-child hierarchy in their models.[…]
Read moreExtract Numbers/ Text only from sentences
I saw similar problem posted in Power BI Community and thought this is worthy of a postHere is the sample[…]
Read moreRemoving Duplicate Rows in Power BI
Duplicate rows can be removed both using Query Editor and DAX We will use this simple data ITEMS Amount ENTITY[…]
Read moreAdding Calculated Row / Calculated Items Using Power Query
Following are the Revenue and Cost of Revenue of 3 Giant technology Companies for 3 years ENTITY ITEMS 2016 2017[…]
Read more