Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Above is an example table of data where I'm looking to create the 'DelValue' column with DAX.
The 'DelValue' column is 'Value'- 'RefValue' derived from:
(Run = 2, ATD=1, Value=4) - (Ref=1 becomes Run=1, ADT=1, Value=6)
In this example the Ref assumes the Run, the ATD matches and the two values, Value and RefValue a subracted to create the DelValue.
My current path has been to find the RefValue with the Run and Ref switch and matching ATD then subtract the value of the Run, but i'm having very little succes and could use a few more options.
I can complete this with joining tables and matching Ref , ATD to Run ATD, but would really like to do this with the table join process as it is heavy on compute.
Any help is appreciated 🙂
Sorry not following at all how you've come up with these values. Can you please try to explain again with clear examples of how each value is calculated.
Phil
Proud to be a Super User!
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 |
---|---|
10 | |
9 | |
8 | |
7 | |
6 |
User | Count |
---|---|
15 | |
13 | |
11 | |
9 | |
8 |