Introducción Soy consultor de Administración de Bases de Datos y varias veces, en el pasado, me pidieron una buena herramienta para generar informes rápidos para obtener información sobre la compañía, como ventas totales, ventas por año, mes, semana, etc. SSAS es una tecnología de Business Intelligence (BI) que Microsoft compró a Panorama Software en 1996. […]| SQL Shack – articles about database auditing, server performance, data reco...
This article aims to show how you can speed up distinct count calculations in Power BI using the built-in user-defined aggregations feature. The user-defined aggregation feature in Power BI is designed to work with direct query models and usually gets used for calculations such as SUM, MIN, MAX etc. However, it can also work well … Continue reading Speed up Distinct Count calculations in Power BI using Aggregations The post Speed up Distinct Count calculations in Power BI using Aggregations...| Phil Seamark on DAX
Background I recently shared on Twitter a 7-module learning path on MS Learn that teaches all you need to know about calculation groups in Power BI. This learning path is an excellent course, and I highly recommend it. However, as part of this exchange, I received a reply from someone lamenting that calculation groups are … Continue reading Using PowerShell to create Calculation Groups in Power BI Desktop The post Using PowerShell to create Calculation Groups in Power BI Desktop appeared fi...| Phil Seamark on DAX