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 moreAuthor: Abu Hasan
Text.Split using DAX
This post was inspired by one of my solutions in the Community. Click here to check the question and answer[…]
Read moreMind Reader in Power BI
Here is a little game / puzzle I created in Power BI
Read moreReplicating 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 moreGrouping and Aggregating a Table stored in a DAX Variable
Suppose we have 2 tables as follows Grade1 Subject Marks Maths 90 Physics 80 Chemistry 70 Grade2 Subject Marks Maths[…]
Read moreUsing M to do calculation across multiple columns in Power Query
In my earlier post I had shown a way of Aggregating Values in Multiple Columns using DAX. Using M its[…]
Read moreShow items with no value
By default, Power BI won’t show items which do not have values. The following picture shows that Products “Apples” and[…]
Read moreObtain Last Working Date before Current Row Date
Assuming Working Days are from Monday to Friday, we want the following First Add a custom Column to identify day[…]
Read moreTriggering Bookmarks by Clicking Visuals
To see the bookmarks in action click any of the first 3 charts. Currently bookmarks can only be triggered by[…]
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 more