Forum Discussion

ChinoZambrano93's avatar
ChinoZambrano93
Regular Visitor
6 years ago

Difference between dates using two tables

I currently have two tables, Catalogue of Works and Date Table In The Work Catalog fields are the Start Date and End Date fields, these fields have an inactive relationship with the Date field ...
ChinoZambrano93's avatar
ChinoZambrano93
Regular Visitor
6 years ago

Thank you for your response @v-deddai1-msft , attached more images about visualizations, tables and model.

It's two boards,

1. Catalogue of Works, where I have the following fields: Rubro(Task), Start Date, End Date, Duration and Daily Value.
2. Date Table

Both tables are related by the Date and Start Date fields, an active one-to-many relationship.

The result I need is an array where the Rows field has the Rubro field, the columns in the Date field, and in the Value field a measure that allows me to place the daily values between the start and end dates of each item.

Please help...

ChinoZambrano93_0-1594402980293.pngChinoZambrano93_1-1594402987880.pngChinoZambrano93_2-1594402998730.pngChinoZambrano93_3-1594403004415.png

v-deddai1-msft's avatar
v-deddai1-msft
Community Support
6 years ago

Hi ChinoZambrano93 ,

 

Just show us some sample data and your expected output by onedrive for business. I still can't see your screenshots since they are too small.

 

Best Regards,

Dedmon Dai