|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
<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> <span class="dd-function">ADDCOLUMNS</span> <span class="dd-parenthesis">(</span></div><div><span class="dd-ln">3</span> <span class="dd-function">FILTER</span> <span class="dd-parenthesis">(</span></div><div><span class="dd-ln">4</span> <span class="dd-function">ALLNOBLANKROW</span> <span class="dd-parenthesis">(</span> <span class="dd-column">Customer[Birth Date]</span> <span class="dd-parenthesis">)</span><span class="dd-parenthesis">,</span></div><div><span class="dd-ln">5</span> <span class="dd-function">NOT</span> <span class="dd-parenthesis">(</span> <span class="dd-column">Customer[Birth Date]</span> <span class="dd-operator">=</span><span class="dd-operator">=</span> <span class="dd-function">BLANK</span> <span class="dd-parenthesis">(</span><span class="dd-parenthesis">)</span> <span class="dd-parenthesis">)</span></div><div><span class="dd-ln">6</span> <span class="dd-parenthesis">)</span><span class="dd-parenthesis">,</span></div><div><span class="dd-ln">7</span> <span class="dd-string">"# Customers"</span><span class="dd-parenthesis">,</span> <span class="dd-function">CALCULATE</span> <span class="dd-parenthesis">(</span> <span class="dd-function">COUNTROWS</span> <span class="dd-parenthesis">(</span> Customer <span class="dd-parenthesis">)</span> <span class="dd-parenthesis">)</span></div><div><span class="dd-ln">8</span> <span class="dd-parenthesis">)</span> <span class="dd-function">order</span> <span class="dd-function">by</span> <span class="dd-parenthesis">[</span># Customers<span class="dd-parenthesis">]</span></div></code><div class="dax-do-try"><a target="_blank">Try it</a></div></div> |
|