Forum Discussion
Issues with Query Parameters Needing to Refresh Data Source
Hi there, fairly new PBI user here - proficient at Tableau, but learning PBI at a client's request. All self-taught, no formal training, working in PBI for about 2.5 weeks. I'm having trouble wi...
If I'm following you correctly, it's somewhere in between. To start with, it should just use a running total up to the point where the next sequential project doesn't fit (row 10 in column C and row 12 in column D of the picture I posted). Then, I need it to essentially skip down the ranking until a project "fits" into the remaining funds, update the new cumulative total, and then try to fit another project until successful or until no projects remain.
I've not compared the logic that you first described with this - I think that would produce different results.
Can you post your current DAX column formulas? The issue I forsee with what you are doing is essentially the "looping" aspect of it, which is not a strong suite for DAX.