DAX has 2 functions that allow you to JOIN tables and columns i.e. NATURALINNERJOIN & NATURALLEFTOUTERJOIN, although there is no...

In this blog let's take a look at why your DAX calculations are returning 100% instead of a fraction of the grand total. In DAX you can...

I have been thinking about this for a while, a series of blogs where I try to explain how a particular piece of DAX code works. For this...

As the title says how do you really do it? Because you can go from DirectQuery <> Dual > Import but you can't go from Import to Dual or...

DAX doesn't have the concept of global variables so reusing a piece of code by referencing it somewhere else isn't possible, luckily the...

As the title suggest let's see how to move (technically recreate) a PBI dataset in PBI service into a different workspace, the gist of...

In this blog let's see how to create Partitions in SSAS Tabular with the help of Tabular Editor, I am using TE3 as it works best when...

UPDATE: saving metadata as TMDL format now allows easy merging. Power BI's June 2023 update introduced a feature that allows you to...

In this blog I want to show how you can load the Tabular DLL to connect Python with Power BI, SSAS, or PBI Service. I am going to refer...