Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi!
Is it possible to create a table from another table where you calculate the change of variable. In my table I have many variables for road condition. The same road is measured many times and i'd like to create a table where I can see how the values have changed between runs. In the picture the blue table is the state my data is now and the green is the desired outcome. Thanks in advance!
.Picture
Solved! Go to Solution.
Yes, it's possible although a little unusual to go down to individual value differences since power bi is generally good for aggregations and visualising sequences.
You could create a calculated column similar to this:
DiffPreviousYr = VAR _year = road[run] VAR _road = road[rd] VAR _dist = road[dist] VAR _previousVal = CALCULATE(SUM(road[val1]), FILTER(road, road[dist] = _dist && road[rd] = _road && road[run] = _year - 1)) RETURN road[val1] - _previousVal
and, for your visualisation (which includes road, distance and year , and the calculated column) you would need to use slicers or filters on each of those columns so, for example, year = 2019, run = 1, distance = 100
Yes, it's possible although a little unusual to go down to individual value differences since power bi is generally good for aggregations and visualising sequences.
You could create a calculated column similar to this:
DiffPreviousYr = VAR _year = road[run] VAR _road = road[rd] VAR _dist = road[dist] VAR _previousVal = CALCULATE(SUM(road[val1]), FILTER(road, road[dist] = _dist && road[rd] = _road && road[run] = _year - 1)) RETURN road[val1] - _previousVal
and, for your visualisation (which includes road, distance and year , and the calculated column) you would need to use slicers or filters on each of those columns so, for example, year = 2019, run = 1, distance = 100
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
84 | |
76 | |
73 | |
42 | |
36 |
User | Count |
---|---|
109 | |
56 | |
52 | |
48 | |
42 |