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.…