Tag: Power BI

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

Calculating Percent Profit Margins Using DAX In Power BI

Working out your profit margins in Power BI with a basic data set can seem like it requires a few steps. You may watch the full video of this tutorial at the bottom of this blog. Maybe you think you need to use calculated columns to get the result. Well, you certainly don’t need to

Continue reading

Using Variables In Power BI – A Detailed Example

using DAX variables in power bi post image, How To Use Variables In DAX Power BI

In this post, I’ll show you how to use and declare variables within your DAX formula in Power BI. You may watch the full video of this tutorial at the bottom of this blog. Variables are a real game-changer for the formula bar in Power BI. Being able to break down your more complex formulas

Continue reading

Using SAMEPERIODLASTYEAR To Compare The Difference Between This Year & Last Year

Using SAMEPERIODLASTYEAR To Compare the Difference Between This Year & Last Year

In this post, I run through how to use SAMEPERIODLASTYEAR, a time intelligence function, to compare results from this year with those of last year. You may watch the full video of this tutorial at the bottom of this blog. If you want to start creating compelling reports with strong insights into information over time,

Continue reading

Enterprise DNA Learning Summit August 2019 – Final Day Wrap Up

We have reached the end of this quarter’s Learning Summit! What a fantastic event it has been. Thank you to all those who attended any session or have watched any of the replays. Always appreciate the feedback that comes in. Just to wrap up for the summit, I thought I would review some of the

Continue reading