Following our discussions on Fixed and Exclude LODs in earlier articles, you should now be fairly comfortable with these concepts. Therefore, tackling Include LOD should be relatively straightforward. Let’s dive in without further ado.
In a prior article, I illustrated and demonstrated the process of converting Tableau’s fixed level of detail (LOD) to Power BI. In this piece, I will extend this effort by guiding you through the translation of the EXCLUDE LOD to Power BI DAX.
Continue reading
If you’ve navigated Tableau’s powerful Level of Detail (LOD) function, you know its complexity and potential for creating impactful visualizations. Now, whether you’re transitioning from Tableau to Power BI or need to excel in both platforms with limited Power BI skills, fear not! In this series, we’ll unravel the mysteries of applying Tableau’s three main LOD functions in Power BI.
Continue reading
Need to connect Tableau to a dataset or semantic model in PowerBI(now Fabric)?It is not as difficult as you may think.
Continue reading
If/esleif/else is one of the the most used functions in Tableau calculation and unfortunately, it can not be applied verbatim in Power BI to achieve the same goal. The equivalent function in Power BI DAX language is the Switch() function and it works especially well on multiple scenarios, it can be used to convert either if/elseif/else statement of possibly case/when query in Tableau.
Continue reading
Converting a highly intricate Tableau report to Power BI, or vice versa, might seem daunting at first. However, I’ve discovered that it doesn’t have to be overwhelming if you approach it methodically, breaking it down into manageable steps. It becomes even simpler if we begin with a foundational report or data source, such as the widely-used Superstore data source. For this particular scenario, I opted for the Tableau data source instead of the Power BI AdventureWorks, as the Superstore data source is more accessible and user-friendly.
Continue reading