Over 10 years we help companies reach their financial and branding goals. Maxbizz is a values-driven consulting agency dedicated.

Gallery

Contact

+1-800-456-478-23

411 University St, Seattle

maxbizz@mail.com

Detecting Aggregation in Power BI Desktop

In the September 2018 release of Power BI Desktop, Microsoft introduced a new game-changing feature in the world of data analytics: “Aggregations”. I feel that Aggregations will provide much flexibility when it comes to handling large data sets in Power BI.  With this new feature, users can define detail-level and aggregate-level information separately and Power BI […]

How to write your SQL query in DAX?

Obviously, T-SQL and DAX are two different query languages and they serve entirely different purposes. However, as someone from a database development background, when I learnt DAX initially, I started thinking SQL and tried to achieve the same thing from DAX. The reason for that thinking process is that it is always easy to learn something new when we […]

Introduction to Azure Data Factory V2

It was only a matter of time till the complete Microsoft on-premise Business Intelligence stack was moved to the Azure Paas service. With the introduction of Azure Data Factory (ADF) back in 2015 and the recent launch of ADF V2, which is in public preview for the moment, it is now possible to orchestrate complex […]

Calculating Month to Date using DAX in Power BI

Data Analysis Expressions (DAX) is a powerful formula language that can help you solve challenging problems and leverage the full potential of Power BI or Analysis Services Tabular when implementing business intelligence, data modeling, or analytics solutions. So, in this blog post, I will demonstrate a useful DAX trick we used to address a challenge […]