Sum by date range

[Kris48]

Please, I need your help, I want to build a measure that will display the sum of "units" in a table visualization for Tow_ID, but the measure must check the date range (from and to) for a given Tow_ID. Then, for the assigned date range, it should calculate the sum of units from the occurrences within that date range in the "Units" table.

PBIX: https://drive.google.com/file/d/1pqn-R7L2AGmrJyvUVtjd3Y64fWFSH6Ed/view?usp=sharing 

[v-linyulu-msft]

Thank you, lbendlin, for your prompt response! Your input has been instrumental in resolving the issue, and I appreciate the solid solution you've provided.

Hi, @Kris48 

Thank you for sharing the challenges you've faced. We're thrilled that you've found a solution and appreciate your openness to exploring others' ideas. This insight is invaluable for community members dealing with similar issues.

Once again, thank you for your efforts.

Wishing you all the best!

 
Of course, if you have any new discoveries or questions, please feel free to get in touch with us.
 

Best Regards,

Leroy Lu

[lbendlin · Accepted solution]

Only the first time period overlaps.