strings
2 Topics
extract string from values with different len
Hi, I have several Store[point of sale] column values that are compound names, where there is a code and then the actual point of sale name. For example. 123 Ltd. Sea 234 srlsl Montagna 23456 asd Lake I just want to have the store names Sea, Montagna, Lake appear in a barplot. How do I extract them? Thank you very muchSolved667Views0likes3CommentsHow to use something similar to CALCULATE with a string Column
Hi, I need to do a filter very similar to this: XXX = CALCULATE( SUM('All Activity '[NAME]), FILTER('All Activity ','All Activity '[TASK] = "Design Check")) ... but the column which I need to filter ('All Activity '[NAME]) is a column that contains STRINGS, same as the value that I need to obtain, so I can't use CALCULATE, or SUM but I'm completely ignorant of which options could I use. I tried changing SUM by ALL, but I got an error that explains that I'm getting multiple values where there is only one value expected. If someone can help me, would make my day 🙂Solved4KViews0likes4Comments