Retrieving previous period values in Power BI is a common task, but retrieving previous week values requires some special attention. In this tutorial, I’ll discuss two straightforward and versatile methods for obtaining Power BI previous week values that can be useful additions to your toolbox, one using DAX and another one using Power Query. You
Subsequent to a recent DAX pop quiz that I prepared and posted on LinkedIn, one of the people who responded to the quiz raised a fascinating idea, via which text columns no longer needed a numeric sort column to put them in proper order. I experimented with this new approach and it worked beautifully. In
In this tutorial, we’re going to take a look at a piece of DAX code that you might have written in your DAX journey. You might also have been confused as to how this code is actually working, and how both Row Context and Filter Context seem to be interacting with each other in just
I thought it’d be interesting to find a way to highlight functions and operators in Power BI that you may haven’t come across before, deeply buried in the menus, or those that you may have seen, but don’t really know what they do. For this tutorial, I’d like to highlight the Power BI Modulo and
For this blog, I’d like to give an overview of how you can speed up your Power BI development. I always think about ways on how we, at the Enterprise DNA community, can empower ourselves and the Power BI community, in general, to develop much quicker inside of Power BI. I observed many areas of
