Forum Discussion
Solved
Adding a column with an incremental count based on multiple selections in another column.
That subject doesn't even make sense to me and I'm writing it... Basically I have a database that has a stupid multi select field in it which means that it can store multiple values and I need to...
Perfectly doable, but not trivial - depending on the exact shape of your input data - have a look at the file: https://www.dropbox.com/s/l4fdvv3ql161p28/PBI_AllocateCategories.pbix?dl=0
Perfectly doable, but not trivial - depending on the exact shape of your input data - have a look at the file: https://www.dropbox.com/s/l4fdvv3ql161p28/PBI_AllocateCategories.pbix?dl=0
Apologies for the delay. I've only just got around to downloading your example.
Thankyou very much indeed. That was very useful providing the PBIX file -- it allows me to see exactly how you built it up to the final result. Now I just have to try and replicate that with my data.
Many thanks again for pointing me in the right direction.
Kind regards,
D.