Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi. I am a beginner in Power BI; I do not know if this is the right forum.
I have the following table:
Year / Week / Value
2015 / 27 / 1000
2015 / 28 / 1010
2016 / 27 / 1200
2016 / 28 / 1205
I need to plot the value growth for each week YoY, ie 1200/1000 = 120% for the week 27 (YoY) and 1205/1010 = 119.3% for the week 28 (YoY)
I tried to do this by creating a column and a measure, but can not find the way.
The year and week, are values and no dates.
Some help?
Hi, I just worked on your problem.. If this is column of two years then the below calculation will work:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
36 | |
33 | |
18 | |
18 |