Using SUMIF and COUNTIF functions in Power BI

Using SUMIF and COUNTIF functions in Power BI

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...
Silver lining for Analytics Amid COVID-19 Pandemic

Silver lining for Analytics Amid COVID-19 Pandemic

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...
Using SUMIF and COUNTIF functions in Power BI

Using SWITCH function in DAX

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...