Category: Enterprise DNA

A Deep Dive Into The TREATAS Function In Power BI

In this tutorial, we’ll dive into one of the most advanced DAX functions in Power BI called the TREATAS function. If you can understand TREATAS, you’ll see that it has so many applications for you across all reports and dashboards which you’ll be creating inside Power BI. TREATAS allows us to simplify our model but

Continue reading

Effective Techniques for Profit Prediction Using Power BI

What I want to cover with this tutorial are some great examples of profit prediction in the future using Power BI. To achieve this in Power BI you need a number of different modelling and formula techniques, but you must be able to use them correctly and simultaneously. When it comes to the output that

Continue reading

4 Techniques To Re-Use Moving Averages In Power BI

In this tutorial, I’m going to teach you how to highlight trends by using moving averages in Power BI in various ways. We can calculate one moving average and easily transfer the same formula into calculating other moving averages. All that’s required is changing one parameter inside the formula. This is a technique which I

Continue reading

Launching The Enterprise DNA Membership License

Today we launch a brand new offering from Enterprise DNA.  After a tremendous amount of feedback on our comprehensive education platform we are now introducing a tailored version of our membership offering for organisations of any size using Power BI around the world.  This will be called the Enterprise DNA Membership License  This new license provides an opportunity for groups and teams of any size to access our platform

Continue reading

Top 3 Best Practices To Organize Your Power BI Models

Today, I’m going to run through an insightful discussion about my top 3 best practices for organizing Power BI models. Placing good organization rules into your models is going to help you immensely in developing more advanced techniques inside Power BI. If I was to give you one simple recommendation when starting out, it would

Continue reading