Forum Discussion

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 ...

Community Support

6 years ago

Hi ChinoZambrano93 ,

It‘s not very clear to me since your second screenshot is too small. Would you please show us some sample data and your expected output. Then we will help you well.

Best Regards,

Dedmon Dai

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...
- 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
  - ChinoZambrano93
    Regular Visitor
    6 years ago
    @v-deddai1-msft ,
    
    I'm sending you an example I did in excel. Maybe this will better understand my problem.
    
    https://drive.google.com/file/d/1dm4H2rAdU1k6Ho4hAopL6t0u3NQoIHtW/view?usp=sharing
    
    Best regards