Number of days gets from defined another table

[bbburcu]

Hi all,

I have a two tables and one table define total number days another table define show sum of quantity by week.

First table show as below,

I want show via measure not column formula in my matrix table as shown below;

Thank you for your support.

BR,

Burcu

[v-yiruan-msft]

Hi @bbburcu ,

Could you please provide some sample data in the second table (exclude sensitive data) with Text format and the calculation logic of Values filed in matrix value with backend logic and special examples? It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

In addition, please review the following link. Hope it can help you.

The Dynamic Time Matrix

Best Regards