Forum Discussion
Calculated measure for tables with different data intervals
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
Hi Anonymous
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 XuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi Anonymous
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 XuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.