RADACAD Blog

Latest Power BI and AI articles from RADACAD team

Some Methods for Calculating Quarter in DAX for Power BI

You might have wondered that there is no DAX Quarter function in Power BI. Here in this short blog post, I explain some easy methods for calculating quarter. If you like to learn more about Power BI, read Power BI book from Rookie to Rock Star. Sample Data To start this example, you can open Read more about Some Methods for Calculating Quarter in DAX for Power BI[…]

Custom Format Fields and Measures in Power BI

If you have been watching Power BI news recently, you know that Power BI fields now support custom formatting. In this short blog article, I am going to explain how to use this feature to achieve your custom formatting. You can do things like showing () for negative values, showing custom date/time formats, and etc. Read more about Custom Format Fields and Measures in Power BI[…]

Some of Key Influencers Visual Features

Key Influencers visual is now generally available ( no preview ), so having updated version of the  Power BI desktop, it is no more a preview feature. This visual is a good one for analysing the data. as I have explained in the post about it ( see here). Now let see some other features Read more about Some of Key Influencers Visual Features[…]

From and To Date Slicers in Power BI: Filtering Based on Two Fields

Power BI date slicers can be used to filter based on one field. However, what if in your dataset, you have a FROM and TO (or Start and End) Date? In that case, you’d most probably want to use the slicer to filter the report in such a way that it shows all data in Read more about From and To Date Slicers in Power BI: Filtering Based on Two Fields[…]

Scheduled Snapshot of the Power BI Data and Report

How many times you have been thinking to see is this possible to store the data of the Power BI report every day, every week or month. How many times, you thought of how to take a snapshot of the data in the Power BI dataset or report at a specific point of times? Well, Read more about Scheduled Snapshot of the Power BI Data and Report[…]

Using Data Category to Have a Better Visualization in Power BI

There are some field properties in Power BI such as formatting, which is obvious to use. However, some configurations on the field level, such as Data Category, is not very well known. Data Category is a configuration that can be helpful in multiple visualizations, In this short article, I’m explaining how to use this option Read more about Using Data Category to Have a Better Visualization in Power BI[…]

Form Processing Workflow with AI Builder- Part 2

As I mentioned in the last post, I want to create a workflow that I can easily scan evaluations forms, extract the values in the forms and then able to put them in another folder, so I can access them via Power BI to analyze the evaluations. In the first post, I create my form Read more about Form Processing Workflow with AI Builder- Part 2[…]

Form Processing Work flow- Create Form Processing Model Part 1

Another exiting new update in AI Builder is Form Processing. With for Processing you able to train the model with forms you have and AI builder able to detect each session of the form and the related values. This feature is so exiting form as for 5 years I am one of the organizer of Read more about Form Processing Work flow- Create Form Processing Model Part 1[…]

Prediction Model in Azure Notebooks using Python: a Sample Project by Microsoft

As I mentioned in Post, Azure Notebooks is combination of the Jupyter Notebook and Azure. There is a possibility to run your own python, R and F# code on Azure Notebook. In post series, I will share my experience working with Azure Notebook. First, in this post, I will share my first experience of working with Read more about Prediction Model in Azure Notebooks using Python: a Sample Project by Microsoft[…]

Get Images from Web Page Into the Power BI Report Using Power Query

Power Query can connect to a web page and get data from there, and I have explained it before in my article about movies data analysis. However, the default way of getting data from the web page doesn’t fetch images into your report. Images in a webpage come through their own URL. If you can Read more about Get Images from Web Page Into the Power BI Report Using Power Query[…]