取特定字符前面的数如果找不到怎么处理

shufeabb

取特定字符前面的值.rar (14.64 KB, 下载次数: 7)

2022-1-17 21:04 上传

点击文件名下载附件

看见星光

大道至简一行

=IFERROR(MID([@单据编号],1,FIND("/",[@单据编号])-1),[@单据编号])

sayhi95

简单加个判断就行了

123-456789

友情参与！

luzwales

<div class="dax-do-query"><code class="dd-lnw-1"><div><span class="dd-ln">1</span><span class="dd-function">EVALUATE</span></div><div><span class="dd-ln">2</span>&nbsp;&nbsp;&nbsp;&nbsp;<span class="dd-function">ADDCOLUMNS</span>&nbsp;<span class="dd-parenthesis">(</span></div><div><span class="dd-ln">3</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="dd-function">FILTER</span>&nbsp;<span class="dd-parenthesis">(</span></div><div><span class="dd-ln">4</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="dd-function">ALLNOBLANKROW</span>&nbsp;<span class="dd-parenthesis">(</span>&nbsp;<span class="dd-column">Customer[Birth&nbsp;Date]</span>&nbsp;<span class="dd-parenthesis">)</span><span class="dd-parenthesis">,</span></div><div><span class="dd-ln">5</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="dd-function">NOT</span>&nbsp;<span class="dd-parenthesis">(</span>&nbsp;<span class="dd-column">Customer[Birth&nbsp;Date]</span>&nbsp;<span class="dd-operator">=</span><span class="dd-operator">=</span>&nbsp;<span class="dd-function">BLANK</span>&nbsp;<span class="dd-parenthesis">(</span><span class="dd-parenthesis">)</span>&nbsp;<span class="dd-parenthesis">)</span></div><div><span class="dd-ln">6</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="dd-parenthesis">)</span><span class="dd-parenthesis">,</span></div><div><span class="dd-ln">7</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="dd-string">"#&nbsp;Customers"</span><span class="dd-parenthesis">,</span>&nbsp;<span class="dd-function">CALCULATE</span>&nbsp;<span class="dd-parenthesis">(</span>&nbsp;<span class="dd-function">COUNTROWS</span>&nbsp;<span class="dd-parenthesis">(</span>&nbsp;Customer&nbsp;<span class="dd-parenthesis">)</span>&nbsp;<span class="dd-parenthesis">)</span></div><div><span class="dd-ln">8</span>&nbsp;&nbsp;&nbsp;&nbsp;<span class="dd-parenthesis">)</span>&nbsp;<span class="dd-function">order</span>&nbsp;<span class="dd-function">by</span>&nbsp;<span class="dd-parenthesis">[</span>#&nbsp;Customers<span class="dd-parenthesis">]</span></div></code><div class="dax-do-try"><a  target="_blank">Try it</a></div></div>