topic String breaking with comma separator in DAX Commands and Tips

String breaking with comma separator

Anonymous — Sun, 25 Apr 2021 16:38:18 GMT

Just wanted to save string value into 6 measures.

String = "David, John, Ali, Simon, Felix, Andy"

Answer measures will be

Person1 = David

Person2 = John

Person3 = Ali

Person4 = Simon

Person5 = Felix

Person6 = Andy

Re: String breaking with comma separator

Fowmy — Sun, 25 Apr 2021 21:41:33 GMT

Anonymous

I am not sure what is the idea behind creating measures from string, but, you can do so using the Tabular Editor. Please refer to this snippet.

https://docs.tabulareditor.com/Useful-script-snippets.html

Re: String breaking with comma separator

Anonymous — Mon, 26 Apr 2021 04:19:50 GMT

Anonymous

Are you absolutely sure you know what you're doing? Would you care to explain what you're really up to, please?