Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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
Solved! Go to Solution.
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
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
9 | |
7 | |
7 | |
6 |
User | Count |
---|---|
21 | |
11 | |
10 | |
9 | |
8 |