This is a very unique example of Time Intelligence in Power BI, especially when working with workdays and weekends. This tutorial came ftom a request from the Enterprise DNA Support Forum, where a member needed to get the day for each weekday and the day of each weekend into their Date table. I’ve seen this
In this blog post, I want to go over an advanced DAX pattern about how to create custom dynamic segmentation in Power BI. You can apply this great technique to many scenarios to gain meaningful insights. Dynamic groups are created when a range of different customers are segmented based on different metrics like sales, margin
Today, we are re-launching the Enterprise DNA Ecosystems. But this month we are doing it slightly differently. The Ecosystems is a way for all of those connected through our membership platform to connect with each other and collaborate around scenarios similar to your industries or job roles. Last time around, we saw some great connections formed and some interesting discussions around similar data scenarios and
In this tutorial, I’m going to show you a real-world insight that enables you to utilize project or opportunities data to create a Revenue Forecast in Power BI. This technique is extremely relevant to CRM systems. This can also be used on your captured information like Sales and Projects, and also on potential revenue forecasts.
In this tutorial, I’ll go through a budget allocation technique in Power BI where you allocate Budgets at a monthly level versus Sales or Transaction Data at a daily level. This scenario is very common when working with any type of forecasted information. As an example, you may have Sales that happen every day, but
