Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello everyone,
I want to create a measure which subtracts the AVERAGE GAP between two prices from different tables. i mean average GAP because there might be more than two prices within a day.
The tables are:
Date | Price Product A |
01-feb | 1,2 |
05-may | 1,3 |
06-ago | 1,09 |
06-ago | 1,1 |
07-sep | 1,5 |
Date | Price Product B |
01-feb | 0,9 |
05-may | 1,05 |
06-ago | 0,8 |
06-ago | 0,75 |
12-nov | 0,7 |
Date | Average Price A | Average Price B |
01-feb | 1,2 | 0,9 |
05-may | 1,3 | 1,05 |
06-ago | 1,095 | 0,775 |
07-sep | 1,5 | - |
12-nov | - | 0,7 |
The expected GAP should be:
Date | GAP Averages |
01-feb | 0,30 |
05-may | 0,25 |
06-ago | 0,32 |
07-sep | 0 |
12-nov | 0 |
In September 7th and November 12th I DONT wanna have these averages calculated or shown on my graph.
Solved! Go to Solution.
@Anonymous , Create a common date Table, then have measures like
A1= Average(Table1[Price Product A])
B1 = Average(Table2[Price Product B])
diff = if([A1] = [B1], blank(), [A1] - [B1])
@Anonymous , Create a common date Table, then have measures like
A1= Average(Table1[Price Product A])
B1 = Average(Table2[Price Product B])
diff = if([A1] = [B1], blank(), [A1] - [B1])
Hello,
Thank you! It has helped me out. One last question. If I want to avoid negative results, how may I?
Hello @amitchandak
It has helped me out. One last question. If I want to avoid negative results, how may I?