topic Re: Sum by date range in DAX Commands and Tips

Sum by date range

Kris48 — Sat, 26 Oct 2024 21:32:14 GMT

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

Re: Sum by date range

lbendlin — Sat, 26 Oct 2024 23:08:12 GMT

Only the first time period overlaps.

Re: Sum by date range

Anonymous — Mon, 28 Oct 2024 09:22:30 GMT

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