topic Calculated measure for tables with different data intervals in DAX Commands and Tips

Calculated measure for tables with different data intervals

Anonymous — Mon, 12 Feb 2024 09:32:02 GMT

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

Re: Calculated measure for tables with different data intervals

Anonymous — Tue, 13 Feb 2024 08:27:18 GMT

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 Xu

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