DAX for Power BI - Dynamic % Change

In this DAX tutorial, we learn how to create a percent change calculation that is dynamic based on the level of the Power BI hierarchy! This is a nice, flexible formula that allows you to view the % change from one period to the next.

To enroll in my introductory or advanced Power BI courses:

Elite Power BI Consulting:

Data Insights Tools:

Connect with me on Twitter!

[BIElite]

NOTE: I realized after publishing the video that the PARALLELPERIOD function works better on the Year, Quarter, and Month levels, particularly for the last value on the visual. Use the code from the first example shown 😊

[SolutionsAbroad]

Great way to repurpose the combo chart, nice one Parker!

[abhishekstatus_]

This is really cool Parker ! Thanks for uploading !

[bawdiestcupid]

Awesome, will try this for week to week!

[MrAszpic]

One measure to rule them all. Thank for sharing!

[gopikaanil]

Can u please show what is your [Total Sales] measure?

[emilyamalkin]

Do I need a date table for this calculation? We have live connection and cannot create date tables. Not sure this would work if I have inconsistent dates (no date table)

[jrekf]

A little late to the party here, but my visual keeps wanting to compare the current period with the next period in the interval (in the future). So I have a -100% change between June 2024 and July 2024. Any idea on how I could filter that out of the visual? I couldn't get the to work off the code, I had to add .[Date] to the date column reference in the DATEADD or PARALLELPERIOD code

[rajeshpatra]

I did the exact same thing, but my column values are not showing, only line value is showing. What may be the problem, and how have you calculated the measure total sales.

[fgkwyuv]

Hi, nice explanation. What if there is no sales for particular day or even consecutive days. Does it show blank space in the visual. I have similar use case at my work

[udusegbe]

Hi..Very good video on calculating daily changes - especially efficiency in avoiding calculation steps with Power Query. Question on daily changes though. How would you factor in daily values that excludes weekends. A use case is with financial stock calculation for daily price changes - where trading does not take place on weekends. Hence price change for Monday, for example, would be difference between Friday and Monday. Thanks for your insights

[bilhanbel]

a question : can we create a table and show year by year change a value and icon next to within the percentage change ? please response if you have an idea thanks.

[vijayvizzu]

Great Tip, but what if we have multiple measures to draw lines and how this variance column chart will work in that case

[OlsoNounas]

Great tip Parker; thank you. Question: Why didn't you use your Current Value variable in your calculate statements? I'm sure there is a reason and I'm interested in finding out. Thank you for all your great videos.

[discrate]

Thanks for sharing, very useful!
Regarding the conditional formatting, I am a bit confused with the rules (actually with the general MS setup).
In the first row number is >=0 AND <= 100 percent then it is green. What about e.g. 150% increase? Why is it not out of the scope?
In the second row percent is >=0 AND number is <= 0 then it is red. If the number is negative then the corresponding percentage is negative as well, cannot be minimum zero. How does it work exactly?

[rajeshm]

Very nice. Could you guide us in HR data set .. Attrition %.. Because avg of opening headcount is very hard. Especially taking from previous c financial year is very tough as it is getting hide when we.filter.

[emirtahiri]

Hi! Thanks for this incredibly helpful video! Although I am having an issue with my date axis. I dont know why my axis is not year sensitive when I am drilling to month level. Can this be about the date table? Do I have to include all the hierarchy levels in my switch function?

[madhurisriram]

What if we have slicer with quarter and select alternate quarters instead of consecutive quarters. Would they show the % change of selected quarters correctly ?

[diegomaldonado]

Hello man, I tried this, and seems like an awesome solution, though, I am getting this error: The True/False expression does not specify a column. Each True/False expressions used as a table filter expression must refer to exactly one column. Do you know why it might be it ? I have created a separate table with this calculation, the total sales is in a different table, that might be it ?

[pabeader]

Can this be extended to go down to the hour and minute?