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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. 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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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