Skip to content

Power BI & Excel are better together

  • Home
  • BLOG
  • My Excel Add-Ins

Category: DAX

Multiple replacements in a Column using Power Query

September 19, 2019 Abu Hasan DAX, 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 more

Text.Split using DAX

September 5, 2019 Abu Hasan DAX

This post was inspired by one of my solutions in the Community. Click here to check the question and answer[…]

Read more

Mind Reader in Power BI

August 4, 2019 Abu Hasan DAX

Here is a little game / puzzle I created in Power BI Share This:

Read more

Replicating PATH function of DAX in Power Query / M

May 29, 2019 Abu Hasan DAX, Power Query

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 more

Grouping and Aggregating a Table stored in a DAX Variable

May 5, 2019 Abu Hasan DAX

Suppose we have 2 tables as follows Grade1 Subject Marks Maths 90 Physics 80 Chemistry 70 Grade2 Subject Marks Maths[…]

Read more

Using M to do calculation across multiple columns in Power Query

February 17, 2019 Abu Hasan DAX

In my earlier post I had shown a way of Aggregating Values in Multiple Columns using DAX. Using M its[…]

Read more

Extract Numbers/ Text only from sentences

January 1, 2019 Abu Hasan DAX, Power Query

I saw similar problem posted in Power BI Community and thought this is worthy of a postHere is the sample[…]

Read more

Funnel Chart with negative Values

November 5, 2018 Abu Hasan DAX

Funnel chart is a beautiful chart in Power BI but if the values for a particular Group in a funnel[…]

Read more

Lookup Between 2 Dates and return a corresponding Value

September 9, 2018 Abu Hasan DAX

Lets begin with the objective (End Result) in mind In Excel we can use an Index Match Array Formula to[…]

Read more

Conditional Formatting of Column and Bar Charts

September 3, 2018 Abu Hasan DAX

Column and bar charts are arguably the most commonly used charts typically used for comparing the relative size of distinct[…]

Read more

Posts navigation

1 2 3 4 Next Posts»

Try My Custom Visuals

  • Multiple Sparklines
  • Hierarchical Bar Chart
  • Beeswarm Chart
Powered by WordPress and Poseidon.