According to Howard Dresner now is the time to gear up and dive into the world of data. So far, 2020 has been a remarkable year for the development of data-driven analytics and business intelligence. At the start of the COVID-19 pandemic, analytics vendors rushed to...
There are many different ways to use the CALCULATE function in DAX. Depending on a task, you might want to put other DAX functions, such as FILTER and ALL, inside CALCULATE. Two common functions that you put inside CALCULATE are the ALL and FILTER functions. Watch our...
With many companies beginning to employ self-service BI, the question of shared work comes to the forefront. Last year, Power BI introduced dataflows that aim to improve collaboration. Power BI Desktop is a great tool when there is one BI analyst working on one PBIX...
When people first start with Power BI, they are often confused about the two functions in DAX – SUM and SUMX. Both functions are doing the aggregation and it may be hard to see the difference between the two. In this article, we take a look at the SUMX function...
With the introduction of paginated reports, Power BI got its own feature similar to the SQL Server Reporting services. With the paginated reports, users can now print and share pixel perfect paginated reports. In this article, we take a closer look at the paginated...
