RADACAD Blog

Latest Power BI and AI articles from RADACAD team

Dual Storage Mode; The Most Important Configuration for Aggregations! Step 2 Power BI Aggregations

Posted on by Reza Rad

An aggregated table can be a layer on the source DirectQuery table. This table needs to have a proper relationship set up with other tables and also the proper storage mode configuration. Storage Mode configuration of the composite model is an important configuration and critical part of setting up the aggregation. The storage mode configuration Read more about Dual Storage Mode; The Most Important Configuration for Aggregations! Step 2 Power BI Aggregations[…]

DAX : Inventory or Stock Valuation using FIFO

Posted on by Philip Seamark

All source files for this article can be downloaded here : A good friend and member of my local Power BI User Group contacted me recently to ask if I might help with a problem he trying to solve in DAX.  He was keen to track the value of items purchased over time in chronological Read more about DAX : Inventory or Stock Valuation using FIFO[…]

Power BI Aggregation: Step 1 Create the Aggregated Table

Posted on by Reza Rad

Aggregation tables are the fast-performing solution for huge DirectQuery tables in Power BI. In the previous blog post, I explained what aggregation is and why it is an important part of a Power BI implementation. Aggregations are part of the Composite model in Power BI. Your first step for the aggregation set up is creating Read more about Power BI Aggregation: Step 1 Create the Aggregated Table[…]

Fun with DAX – A-Maze-ing DAX

Posted on by Philip Seamark

Intro: In my younger days, I enjoyed playing computer games and in particular, maze-based games. So for the latest addition to my series of DAX based games, I thought I would have a crack at building a game in Power BI that allowed the user to appear to control a character through a maze to Read more about Fun with DAX – A-Maze-ing DAX[…]

Exception Reporting in Power BI: Catch the Error Rows in Power Query

Posted on by Reza Rad

To build a robust BI system, you need to cater for errors and handle errors carefully. If you build a reporting solution that the refresh of that fails everytime an error occurs, it is not a robust system. Errors can happen by many reasons, In this post, I’ll show you a way to catch potential Read more about Exception Reporting in Power BI: Catch the Error Rows in Power Query[…]

Image Processing- Invoice recording using Power App, Microsoft Flow and Cognitive Service- Part 3

Posted on by Leila Etaati

  In the last two posts (Post1 and Post2), the process of how to set up a simple Power Apps for the aim of converting the image to text has been explained. The created Power Apps capture a picture from a receipt or any text.  Also, how to create a flow that received the image Read more about Image Processing- Invoice recording using Power App, Microsoft Flow and Cognitive Service- Part 3[…]

Quick Measures in Power BI: You don’t have to write DAX!?

Posted on by Reza Rad

You read it right, you don’t have to write DAX. If you are calculating a year to date, running total, or every rolling average, you may be able to do it without writing a single line of DAX code. How this is possible? With Quick Measures. Quick measures are an easy way to create DAX Read more about Quick Measures in Power BI: You don’t have to write DAX!?[…]

SUM vs SUMX; What is the Difference of the two DAX Functions in Power BI?

Posted on by Reza Rad

Sum and Sumx are functions that often founded to be misleading for many Power BI users. As both functions are doing the aggregation, it seems a bit confusing what is the actual difference between these two. There are many blog posts and articles about each function. I always explain the difference with simple demos in Read more about SUM vs SUMX; What is the Difference of the two DAX Functions in Power BI?[…]

UseRelationship or Role-Playing Dimension; Dealing with Inactive Relationships in Power BI

Posted on by Reza Rad

In a Power BI model, relationships are important for passing filters, filter propagates through relationships. However, sometimes you create the relationship between two tables, and the relationship is a dashed line. In this post, I’ll explain to you everything you need to know about a dashed relationship, or as it called Inactive relationship. I will Read more about UseRelationship or Role-Playing Dimension; Dealing with Inactive Relationships in Power BI[…]

OVERVIEW ON MICROSOFT MACHINE LEARNING TOOLS

Posted on by Leila Etaati

Microsoft Machine Learning Technologies Overview Artificial intelligence and specifically Machine learning can bring lots of benefit to the business owner. Many businesses using Microsoft data platform tools for many years. Microsoft employed machine learning in creating their products such as Xbox, Bing Search and so forth for a while. However, from 2014 they start to Read more about OVERVIEW ON MICROSOFT MACHINE LEARNING TOOLS[…]