Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
How to get "Y to y growth" Colum individual growth percentage
Please anyone help me
Solved! Go to Solution.
Hi @Lakshmi20 ,
Based on my research, I think [total sales] is a measure.
Here's my solution.
Sample data is as follows.
[total sales] is a measure as
total sales = SUM('Table'[sales])
Then you can create a measure for returning the previous year's sales.
previous sales = CALCULATE([total sales],FILTER(ALLSELECTED('Table'),YEAR([date])=YEAR(MAX('Table'[date]))-1))
Then the [y to y growth] is
y to y growth = DIVIDE([total sales]-[previous sales],[previous sales])
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Lakshmi20 ,
Based on my research, I think [total sales] is a measure.
Here's my solution.
Sample data is as follows.
[total sales] is a measure as
total sales = SUM('Table'[sales])
Then you can create a measure for returning the previous year's sales.
previous sales = CALCULATE([total sales],FILTER(ALLSELECTED('Table'),YEAR([date])=YEAR(MAX('Table'[date]))-1))
Then the [y to y growth] is
y to y growth = DIVIDE([total sales]-[previous sales],[previous sales])
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
hi @Lakshmi20
Info insufficient. Anyway, try like:
YoY% =
VAR salespre =
CALCULATE(
[total sales],
TableName[Year]=MAX(TableName[Year])-1
)
RETURN
DIVIDE([total sales], salespre)-1
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
28 | |
12 | |
10 | |
10 | |
6 |