Forum Discussion
append data from two columns only for distinct count.
Thank you Imke for your patience and assistance. I was finally able to get it using the old copy/paste/paste/merge/remove duplicates way. I was able to get the chart right too - apparently I had the relationship pointing the wrong way. Once I changed the direction, it is now displaying the right values.
Thank you Imke for your patience and assistance. I was finally able to get it using the old copy/paste/paste/merge/remove duplicates way. I was able to get the chart right too - apparently I had the relationship pointing the wrong way. Once I changed the direction, it is now displaying the right values.
Sorry Lenihan to see that the performance of my formula is so poor.
This was a surprise for me as well and I tried to speed it up with no success. M has some unbuilt algorithms that might cause the source to be hit multiple times and there is nothing we users can do about it at the moment (even buffer doesn't work).
But I must admit that I've never come across sth bad like this... :-(