Tag: Logical Functions

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

Budgeting Analysis On Best & Worst Performers Using Power BI

I run through a lot of budgeting analysis because I think using Power BI for this type of analysis is extremely effective. You may watch the full video of this tutorial at the bottom of this blog. Power BI as a tool covers a lot of the analytical components that need to be executed well

Continue reading

New vs Existing Customers – Advanced Analytics In Power BI

If you’re an online retailer or a high frequency sales operation, then understanding your customer base, like if they are new customers or existing customers, is a really high quality insight that you can achieve using advanced analytics in Power BI. You may watch the full video of this tutorial at the bottom of this

Continue reading

Dynamic Segmentation: How To Segment Customers Into Groups Using Advanced DAX

Today, I’m getting complex with DAX, but that’s because I enjoy showing the power of this formula language inside Power BI. I want you to get there too. This is why I always want to get practical about implementation. Dynamic segmentation is a perfect example of a really valuable commercial insight you can extract out

Continue reading