Using Variables in DAX
Variables are used in DAX to optimize the DAX code. The DAX engine evaluates the variables only once, making the code faster and more readable. Using variables in DAX helps…
Understanding the difference between VALUES(), DISTINCT(), ALL() and ALLNOBLANKROW()
DAX is simple but works on the mantra of “Nothing worth having comes easy”. Anything worthwhile requires effort, so don't give up if you're up against it. This blog will…
All the facts you need to know about fuzzy matching!
Power BI users come from different backgrounds and have their own specific business requirements which they address using their business data. Microsoft Power BI has a large user base in Australia. Power…
Testing table functions in measures
DAX is a formula language used for creating calculated columns, measures, and tables. It is a common misconception that the table functions in DAX are used to create calculated tables…
Gallery in a Canvas Power App
Power App platform is a low-code or no-code platform developed by Microsoft to help business owners build apps for their businesses without having to learn app development concepts in detail.…
Creating a Canvas App
Microsoft Power Apps is a low-code or no-code platform developed by Microsoft to help business owners develop a completely configured end to end working app without any knowledge of app…
Importing or Exporting a Power App
Power Apps Essentials training is designed to assist the business users in developing a complete end to end application without having to learn the app development skills in detail. This…
Exploring Table Joins
Table joins are a common data operation performed by data analytics for joining two or more tables. This may result in an outburst of data which does not carry any…
Searching, Sorting and Version Control in Power Apps
Power Apps training in Australia is gaining popularity because this platform provides an easy to learn interface for business users with no prior coding or app development experience. After a…
Solving Data Explosion resulting from CROSSJOIN() in DAX
DAX is Data Analysis Expression language developed by Microsoft to interact with data in various ways. It is a formula language consisting of functions, operations and expressions that return some…