Tag: variables function

Time Tables In Power BI: Solution For POTW #10

Time Tables In Power BI- Solution For POTW #10

On this blog post, I’ll be bringing you the solution for working with time tables in Power BI, which is our Problem of the Week #10. This wasn’t an overly difficult challenge. But still, it was quite a niggly one that threw in quite a few curve balls. You can watch the full video of

Continue reading

Power BI Tips: Retrieving Previous Value Excluding Weekends & Holidays

Power BI Tips Retrieving Previous Value Excluding Weekends and Holidays

In this post, I will show you some Power BI tips and techniques on finding the previous value that accounts for weekends and holidays. This came up in a post by Brian Julius in the Enterprise DNA forum. You may watch the full video of this tutorial at the bottom of this blog. The developer

Continue reading

Find Your Top Clients Across Different Measures in Power BI

Here at Enterprise DNA, we are building an analytical movement with Power BI. Today, I am going to walk you through how you can create an awesome visualization where we dynamically showcase only our top ranked clients using multiple measures in Power BI. You may watch the full video of this tutorial at the bottom

Continue reading

Scenario Analysis Techniques Using Multiple ‘What If’ Parameters

Power BI is an incredible tool to run scenario analysis and what-if analysis examples. I’ve actually never seen or come across an analytical tool that is as effective and intuitive to implement this type of complex analytics. You may watch the full video of this tutorial at the bottom of this blog. The key is

Continue reading

How To Use The EARLIER Function In Power BI – A DAX Tutorial

Most DAX beginners and even intermediate users really struggle in understanding what the EARLIER function does. It also took me a long time to understand how, when and why you should use this function in Power BI. You may watch the full video of this tutorial at the bottom of this blog. In this article, we

Continue reading