Forum Discussion

Kris48's avatar
Kris48
Frequent Visitor
1 year ago
Solved

Sum by date range

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 

 

DAX

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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