Forum Discussion
Simple Loop
Hi team, Can you please assist? Im unsure if such a thing is possible in Powerbi, but can we do looping? Basically i have a table, sample data shown below, showing all the incomes per customer an...
SammyNed I am willing to give this a go, if you can please provide some sample data in a table format with the desired output clearly mentioned.
AlexisOlson this is a problem similar to maximizing subset for a given sum, which can be achieved by genrating all possible subset combinations and their corresponding sum in PQ.
I doubt if it can be achieved in DAX.
smpa01 You mean the multiple knapsack problem? If you can brute force in PQ, I can probably do it in DAX too but a brute force approach has exponential complexity and won't scale well beyond small sets. M is probably necessary for more efficient algorithms.
