Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
21 | |
15 | |
15 | |
11 | |
7 |
User | Count |
---|---|
25 | |
24 | |
12 | |
12 | |
12 |