Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join 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.

Reply
wayersGM
Frequent Visitor

Reference Multiple Columns

 

wayersGM_0-1730397032016.png

 


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 🙂

1 REPLY 1
PhilipTreacy
Super User
Super User

@wayersGM 

 

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

 



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.