Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Guys,
I have a table with 3 columns as shown below. The column "sales gap (usd) column)" is a measure that has a relationship (that is to say, has a connection) with "remaining months to recognize" but the measure is not directly dependent on it.
Now I want to find the difference between the row values in the "sale gap (usd)" column. I add a new column and write this expression:
Diff. in Sales Gap =
'New Deals Goal'[Sales Gap (USD) column] -
IF('New Deals Goal'[Index]=0; 'New Deals Goal'[Sales Gap (USD) column];
LOOKUPVALUE('New Deals Goal'[Sales Gap (USD) column];'New Deals Goal'[Index];'New Deals Goal'[Index]-1))
As seen below:
I have a circular dependency issue. I have read about it and I understand the problem, but how do I solve this?
Thank you.
Solved! Go to Solution.
Hi,
Try this one .
Column =
var A= CALCULATE( MAX('New Deals Goal'[Index]))-1
return
If('New Deals Goal'[Index]=0,
'New Deals Goal'[Sales Gap (USD) column],
'New Deals Goal'[Sales Gap (USD) column] - CALCULATE(SUM('New Deals Goal'[Sales Gap (USD) column]),FILTER('New Deals Goal','New Deals Goal'[Index]=A))
)
Hi,
Try this one .
Column =
var A= CALCULATE( MAX('New Deals Goal'[Index]))-1
return
If('New Deals Goal'[Index]=0,
'New Deals Goal'[Sales Gap (USD) column],
'New Deals Goal'[Sales Gap (USD) column] - CALCULATE(SUM('New Deals Goal'[Sales Gap (USD) column]),FILTER('New Deals Goal','New Deals Goal'[Index]=A))
)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
70 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |