Category: Power BI

ALL Function in Power BI – How To Use It With DAX

Did you know that the ALL function can be used to modify the context of a particular calculation in Power BI? You may watch the full video of this tutorial at the bottom of this blog. Find out everything about how this function works in the post below. What Is The ALL Function In Power

Continue reading

Announcing The Enterprise DNA Scholarship Program

Today we have an exciting announcement at Enterprise DNA. We are launching our scholarship program. We have a desire at Enterprise DNA to impact all users of Power BI around the world, and with the creation of this scholarship program, we feel we can bring a wider reach to our unmatched offering of training and

Continue reading

Using Filter Fields & Visual Interactions To Create Compelling Visualizations In Power BI

I want to show you how you can use filter fields and visual interactions in Power BI to great effect. They create simple and very effective ways to make your visualizations easier and more intuitive for the consumer especially if we need to create groupings of information in our analysis. You may watch the full

Continue reading

Calculate Financial Year To Date (FYTD) Sales In Power BI Using DAX

Calculate Financial Year To Date FYTD Sales In Power BI using DAX

There will be countless times when you will be required to calculate your sales financial year to date, but only the standard date table is available. You may watch the full video of this tutorial at the bottom of this blog. One thing that can seem like a limitation of Power BI is its calendar

Continue reading

Implement Row Level Security In Your Power BI Models

Scale Your Power BI Reporting with Row Level Security

Whenever I think of row level security in Power BI I think scale. You may watch the full video of this tutorial at the bottom of this blog. Within larger organisations, you often need to develop reporting that goes up the chain, but only certain levels should be able to see certain things. To make

Continue reading