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 readingUsing the superstore dataset, supposing we have a certain order quantity target we want to evaluate on all states and give dynamic feedback based on how well we met that target. But this time, we want to do it in Power BI.
Start with same base structure:
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