Tag: Power BI Measure Branching

Use Measure Branching To Speed Up Report Development

In this tutorial, I’m going to show you how I maximized a technique called measure branching to speed up my report development process on my submission for the 10th Power BI Challenge. The Power BI Challenge is a series of scenarios where a data set is provided and participants are asked to deliver the set

Continue reading

Power BI Financial Year To Date Calculations

Power BI Financial Year To Date Calculations

In this tutorial, I’m going to talk about Power BI financial year to date calculations. Achieving a year to date analysis of a selected period is quite complex, but I’ll demonstrate to you a formula technique that enables you to quickly create a cumulative total over your specific financial year. You can watch the full

Continue reading

Power BI DATEADD Function & Time Related Insights

Power-BI-DATEADD-Function-&-Time-Related-Insights

In this tutorial, I’m going to cover the best time intelligence function, the Power BI DATEADD. It’s one of the time intelligence functions that you should introduce yourself to as soon as possible when learning Power BI. You may watch the full video of this tutorial at the bottom of this blog. The Power BI

Continue reading

Calculations In Power BI Using Measure Branching

Measure Branching is a technique in making calculations in Power BI. It’s not something you’ll hear often because it is unique to Enterprise DNA. It’s a methodology that I made to create measures out of measures. You may watch the full video of this tutorial at the bottom of this blog. Calculating The Total Costs

Continue reading

Time Intelligence DAX Functions In Power BI

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

Continue reading