For this tutorial, we’ll branch out to some examples of time intelligence calculations using a combination of DAX functions. This kind of calculation is useful when you want to compare your business data over a certain period. You can do it by days, months, quarters, or years. Aside from the CALCULATE function, using other DAX […] The post Time Intelligence DAX Functions In Power BI first appeared on Master Data Skills + AI ..read more

In this tutorial, we’ll examine an interesting question that was raised on the Enterprise DNA Forum about how to dynamically merge a changing number of columns in a Power Query table. You can watch the full video of this tutorial at the bottom of this blog. This scenario deals with raw data exports that cause […] The post How To Dynamically Merge Columns In A Power Query Table first appeared on Master Data Skills + AI ..read more

I’m going to show you the difference between the Power BI USERELATIONSHIP function and the TREATAS function that are both used when creating DAX measures. You may watch the full video of this tutorial at the bottom of this blog. I got this tutorial idea from a question that was raised on the Enterprise DNA […] The post Power BI USERELATIONSHIP vs TREATAS first appeared on Master Data Skills + AI ..read more

In this tutorial, I’m going to cover a specific technique around Cumulative Total and budgeting information that you might be showing in your reports in Power BI. You may watch the full video of this tutorial at the bottom of this blog. This is a very common question in the Enterprise DNA Support Forum. It’s […] The post Showing Cumulative Total Only Up To A Specific Date In Power BI first appeared on Master Data Skills + AI ..read more

In this tutorial, you’ll go through different Power BI design ideas that you can use and implement in your inventory management dashboards. This is the final step when creating a report in Power BI. You need to clean it up so that it gives off a better impression to its users. Previous tutorials have discussed […] The post Power BI Design Ideas For Inventory Management Dashboards first appeared on Master Data Skills + AI ..read more

Here’s a Power BI visualization technique that you can utilize within your reports by using large images in the background. You may watch the full video of this tutorial at the bottom of this blog. In a lot of demos I have created and showcased during the Enterprise DNA webinar series or learning summits, I […] The post Power BI Visualization Technique: Learn How To Create Background Design Plates first appeared on Master Data Skills + AI ..read more

In this tutorial, I will explain how to modify shape maps Power BI visualizations. Shape maps are great for spatial analysis and they go well with Power BI reports and dashboards. They can also be used as a standard map feature. You can watch the full video of this tutorial at the bottom of this […] The post Shape Maps Power BI – How To Create And Repair first appeared on Master Data Skills + AI ..read more

In this tutorial, I show you how you can layer multiple “What If” analysis or scenarios in Power BI, one on top of each other. It takes your analytical output through the roof if you use this technique effectively. You may watch the full video of this tutorial at the bottom of this blog. As […] The post Advanced Analytics in Power BI: Layering Multiple ‘What If’ Analysis first appeared on Master Data Skills + AI ..read more

Power BI SQL Query For this tutorial, we are going to delve deeper and understand how Query Dependencies work in Power BI. Query Dependencies show you how the queries are linked together inside Power BI. You can see which queries depend on other queries or tables. This is useful when you plan to do a […] The post How Query Dependencies Work In Power BI first appeared on Master Data Skills + AI ..read more

In this blog post, I will show a really unique and specific example where I’m going to hone in on how you can combine lots of the techniques that I’ve described in many previous tutorials to come up with profit margin changes. You may watch the full video of this tutorial at the bottom of […] The post Analyze Profit Margin Changes Overtime – Analytics with Power BI and DAX first appeared on Master Data Skills + AI ..read more