by Nikolai Pavlov | Dec 5, 2020 | Video
In this video, we’ll take a look at the SWITCH function in DAX. The SWITCH function in DAX compares a declared expression against all values. If the expression matches the value then it returns the result, if it doesn’t, it keeps moving down the list until the value...
by Nikolai Pavlov | Nov 30, 2020 | News
Looking at the legendary Russian heavy-duty truck, KAMAZ, one may not necessarily think of business intelligence (BI). Indeed, KAMAZ trucks are all about raw power, rough looks and reliability. Under all operating conditions, be it the Arctic tundra or the African...
by Nikolai Pavlov | Nov 20, 2020 | News
Earlier this week Microsoft released the November update for Power BI. In this article, we take a look at some of the new features that came out this month. As in most previous updates this year, the November update focuses mainly on the reporting and visualization...
by Nikolai Pavlov | Nov 16, 2020 | Video
The IF function in DAX checks if a given expression is true or false, and returns one value when it’s true, otherwise it returns a second value. In DAX you can write the IF function in two different ways: in columns and measures. The example of creating a...
by Nikolai Pavlov | Nov 7, 2020 | News
With new tools being developed, some thought the best days of Excel were over. However, Microsoft has been regularly adding new updates to its legendary spreadsheet application. This still makes it a go-to data analytics solution in most companies. In its latest...
