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