Divide sum of values in measure by values in second table joining by month and product

[MarcinSV]

Hi to all,

I'm newly in PBI and was trying to do my best working on solution but I gave up for this moment.

I have to tables:

TABLE A (date|prod|value)

2019-01-01 | prod A | 300

2019-02-01 | prod B | 100

 TABLE B (prod|year|month|value)

Prod A | 2019 | 1 |30

Prod B | 2019 |2  |22

Now this values of month (300 and 100) I'd like to use count an average for PROD_NAME by MONTH, i.e.:

for PRODUCT PROD A, month 1 = 300 / 30 = 10 AVG

for PRODUCT PROD B,  month 2 = 100 / 22 = 4,54 AVG

I would be greatfull for any help and tips.

All the best!

[MarcinSV]

Does anyone has an idea how to solve it?

I will ask in different way (without product), maybe then I will find by myself the rest solution.

How to divide one value in month (table A) by second value (from different table, B) but exactly for the same month like in table A?

For example:

Table A: in December 2018 value = 300,

Table B: in Decemeber 2018 value = 30

So 300 / 30 = 10

Now I have one measure: Average of working day = SUM(Table A [Sales]) / 22 -> and I need to change this 22 to dynamic, depending on month /year value from table A and put in this place value from the same month/year but from table B. Now I have no idea how to change it using DAX that value from A will "choose" value from B...

[v-jiascu-msft · Accepted solution]

Hi @MarcinSV,

I would suggest you create two tables. Then everything will be easy and clear. Please download the demo from the attachment.

Best Regards,

[MarcinSV]

Thank you very much, now it works great!