Thank you Riny, but I think that is a little too much for me to comprehend. I will need to study this in detail. Thank you for your patience.
Hi Riny, I created a new example and used your technic. It was a bit of a struggle to get the right "(double) rows" deleted, but I found your line ...
Hi Riny, Thx, your solution does the trick by using the split column delimiter. I adapted your solution to meet the result I wanted in this example...
Hi Phil, It is just an example. There is no logic in it. Sorry for that. The actual data is financial data where keywords are submerged in text....
Hi James, you can use the append queries, sort on time and fill, this will do the trick for you. In the end of this YouTube they will demonstrate t...
Wow Velouria, this did the job! I added my table to the datamodel. Entered the measurement in the datamodel as AVERAGEX(VALUES(columname);CALCUL...
Hi Mynda, Thanks for your quick reply. That's really amazing. I must study on this new view. I thought it would be easy and that I just lacked t...