Calculate the difference between mean averages with taking into account blank data

[Anonymous]

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.

[amitchandak · Accepted 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])

https://amitchandak.medium.com/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solution-8e3eccb41bda

[Anonymous]

Hello,

Thank you! It has helped me out. One last question. If I want to avoid negative results, how may I?

[Anonymous]

Hello @amitchandak 

It has helped me out. One last question. If I want to avoid negative results, how may I?