Power BI DAX Functions: MIN(), MAX(), AVERAGE()
DAX Functions are an integral part of every Power BI training because Power BI is incomplete without the knowledge of DAX and DAX is incomplete without the understanding of DAX…
Performance Analyzer in Power BI
Performance analyzer is a topic which hardly finds its way in Power BI trainings in Sydney. The topic is rarely discussed in Power BI trainings in Melbourne too. This does…
Power BI DAX Functions: SUM(), COUNT() and DISTINCTCOUNT()
DAX is a formula language. This means that DAX formulas derive the DAX expressions. DAX functions consists of formulas that perform defined calculations and bring about meaningful information from the…
Creating Filled Maps in Power BI Desktop
Map visualization is a major topic covered during our power bi training in Sydney and Melbourne. This is because map visuals are one of the best communication tools to convey…
Creating Dynamic Bar Chart in Power BI
DAX is much more then creating calculated columns and calculated measures. As the name suggests, Data Analysis Expression (DAX) is the language used to express data. DAX can be used…
Duplicate vs. Reference Queries
A query in Power BI refers to a series of steps performed on the raw data to convert it into a format that is best suited for reporting and analysis.…
Variables and Comments in DAX
In out last Power BI training in Sydney for Power BI Basic course, we were asked "What are variables and comments in DAX". So we decided to dedicate a…
Using Group-by in Power BI for Data Transformation
Data Transformation is a process in which raw data is Transformed into a format that is suitable for fast and precise data processing and for efficient reporting. Data Transformation involves…