Forum Discussion
Solved
Cap Sum by Day
I am not new to DAX but I’m not an expert either. I need some help, please, developing a calculation and I’m not sure the best approach. My data model captures data about utilization of resources. ...
you sample data and the expected outcome don't agree.
Anyway, here's my proposal. You could hide the extra "cap" columns or ignore them.
lbendlin
Super User
Super UserPlease provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523