Calculated measure for tables with different data intervals

[SecretChimpanze]

Hi,

I have two tables - Table A has daily data and Table B has weekly data. They have two common fields - Product and Week Ending.

Problem: I need a Calculated Measure to  get the SUM of the Daily data from Table A and divide that by the value in Table B for the corresponding Product and Week Ending period. Is this possible?  

So something like this --> Table A / Table B where Product & Week Ending matches

[Anonymous · Accepted solution]

Hi @SecretChimpanze 

No relationship between the two tables

You can create a measure as follows.

Measure = DIVIDE(MAX(TableA[Volume]), CALCULATE(MAX(TableB[Volume]), FILTER(TableB, [Product] = SELECTEDVALUE(TableA[Product]) && [Weeking Ending Date] = SELECTEDVALUE(TableA[Week Ending Date]))))

Is this the result you expect?

Best Regards,
Yulia Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.