by Nikolai Pavlov | Dec 17, 2020 | Video
In this video, you’ll see a few examples of using SUMIF and COUNTIF in Power BI. When Excel users come to Power BI, one of their first questions is “How do I use SUMIF?” Turns out, there are no SUMIF and COUNTIF functions in Power BI. However, with...
by Nikolai Pavlov | Dec 13, 2020 | Articles
Even before the COVID-19 pandemic, a lot of hype was around analytics and business intelligence (BI). Experts predicted positive trends in BI adoption and discussed how analytics would help businesses around the world. Then the pandemic changed the world in 2020. Just...
by Nikolai Pavlov | Dec 9, 2020 | News
With experts predicting an over $10-billion industry growth during 2021 – 2024, players in the BI market will be busy in the mergers and acquisitions (M&A) front. Despite a relatively quiet time in 2020, experts are forecasting more M&A deals in the industry...
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 | Dec 1, 2020 | News
To improve its digital tools and data management processes Toyota Ukraine integrated Microsoft Dynamics 365, Teams and Power Platform. Toyota Ukraine is the official distributor of Toyota and Lexus cars, as well as spare parts in the country. The company has more than...
