Tag: DAX Studio

Using DAX TOPN To Calculate Last N Weeks Trend

This tutorial will discuss and solve Problem Of The Week #5 in the Enterprise DNA forum using the DAX TOPN function. The problem requires a solution with 4 requirements. One requirement of the problem is to calculate the dynamic Last N Weeks Trends of a COVID-19 data report. You can watch the full video of

Continue reading

Using Text Functions In Power BI – DAX Tutorial

Using Text Functions In Power BI – DAX Tutorial

In today’s tutorial, I’m going to show how you can use path functions and text functions in Power BI to extract certain words from a given text string. You may watch the full video of this tutorial at the bottom of this blog. In this example, we have two rows of data set and we

Continue reading

Data Caches In A DAX Calculation

Data Caches In A DAX Calculation

In this tutorial, you’ll learn about what data caches do in a DAX calculation. You’ll understand how they work with the formula and storage engines to provide answers to your queries. What Are Data Caches? The storage engine interacts with the formula engine in the form of a data cache. If you recall from the

Continue reading

Query Performance And DAX Studio Setup

This tutorial will discuss about setting up DAX Studio and measuring query performance in Power BI. These information will help detect bottlenecks in the query so that you can eliminate them and optimize your DAX. Setting Up DAX Studio Open the DAX Studio tool and connect your model. In this example, the EDNA Optimizing DAX

Continue reading

Power BI Storage Engine: Simple Math Operations

Power BI Storage Engine- Simple Math Operations

Today’s post will talk about how the storage engine in Power BI can do mathematical operations. This tutorial is helpful if you want to get combined figures without a column or a table. When dealing with easy measures or codes, the best practice is to send them into the VertiPaq storage engine. Unlike the formula

Continue reading