Posted inData & Analysis

Filtering a Column via a Visual AND CALCULATE

Sometimes, just when you think you are getting the hang of the DAX language, something happens that completely baffles you. Such events can cause you to doubt your own learning and progress. But let me assure you – this happens to EVERYONE at sometime or another.…
Posted inData & Analysis

Working with Weeks in Power BI

We often need to deal with data over a period of weeks, so we’re going to show you how to use Power BI to work with Weeks. Let’s suppose we have a Sales dataset with Date, Category and Revenue columns and we want to see how…
Posted inData & Analysis

Split multiple columns into rows in #PowerQuery

Recently, I worked on an interesting problem. Datasource I was working with was a SharePoint list, working with SharePoint lists always turns out to be a difficult task than I first assumed. On top of that, with this particular data source; data was coming as semicolon…