DAX help needed

Question

Afternoon All,&nbsp;I need a little help to get the below working as expected.&nbsp;&nbsp;&nbsp;I have a table of income data,&nbsp; this would inclusdeAmount = Various valuesPayment Date = date of payment&nbsp;SourceCode&nbsp; = Structured source code to track paymentsPayment Method = Cash,&nbsp; Direct Debit etc..&nbsp;I have a custom column" that for the most par works, Everything below execpt the section in bold works.&nbsp; &nbsp;What i want to happen is&nbsp;this exceprt from SQL&nbsp;"casewhen sourcecode like 'A%' and sourcecode not in ('AUGO','AUPO','AURO','AUTO','AUCO','AUFO','OOOO','OAMA','OANA',&nbsp;&nbsp;&nbsp; 'OARS','ZREF','ZBAN','NAUG','AWAO','BUSR') and sourcecode not like 'AV%' then '01_Cash'"&nbsp;I constructed the par in bold and while no errors i dont seem to see in my SourceType Column the CASH value returned?&nbsp;IF anyone has any pointers please fire th&nbsp;SOURECTYPE = IF('Fundraising Inc Report'[SOURCE_LETTER] = "A" &amp;&amp; 'Fundraising Inc Report'[Payment Method]="TAX","TAX",IF('Fundraising Inc Report'[SOURCE_LETTER] = "A" &amp;&amp; 'Fundraising Inc Report'[Payment Method]&lt;&gt;"TAX","Appeals",IF('Fundraising Inc Report'[SOURCE_LETTER] = "C","Corporate",IF('Fundraising Inc Report'[SOURCE_LETTER] = "E","Emergencies",IF('Fundraising Inc Report'[SOURCE_LETTER] = "L","Legacy",IF('Fundraising Inc Report'[SOURCE_LETTER] = "M","Major Donor",IF('Fundraising Inc Report'[SOURCE_LETTER] = "R","Community",IF('Fundraising Inc Report'[SOURCE_LETTER] = "U","Unattributable",IF('Fundraising Inc Report'[SOURCE_LETTER] = "Z","Refunds/Fees", IF('Fundraising Inc Report'[SOURCE_LETTER] = "A" &amp;&amp; NOT(SEARCH("AUGO", 'Fundraising Inc Report'[Source Code (Source Campaign)] ,, 0 ) &lt;&gt; 0 ||SEARCH("AUPO", 'Fundraising Inc Report'[Source Code (Source Campaign)] ,, 0 ) &lt;&gt; 0 ||SEARCH("AURO", 'Fundraising Inc Report'[Source Code (Source Campaign)] ,, 0 ) &lt;&gt; 0 ||SEARCH("AUTO", 'Fundraising Inc Report'[Source Code (Source Campaign)] ,, 0 ) &lt;&gt; 0 ||SEARCH("AUCO", 'Fundraising Inc Report'[Source Code (Source Campaign)] ,, 0 ) &lt;&gt; 0 ||SEARCH("AUFO", 'Fundraising Inc Report'[Source Code (Source Campaign)] ,, 0 ) &lt;&gt; 0 ||SEARCH("OOOO", 'Fundraising Inc Report'[Source Code (Source Campaign)] ,, 0 ) &lt;&gt; 0 ||SEARCH("OAMA", 'Fundraising Inc Report'[Source Code (Source Campaign)] ,, 0 ) &lt;&gt; 0 ||SEARCH("OANA", 'Fundraising Inc Report'[Source Code (Source Campaign)] ,, 0 ) &lt;&gt; 0 ||SEARCH("OARS", 'Fundraising Inc Report'[Source Code (Source Campaign)] ,, 0 ) &lt;&gt; 0 ||SEARCH("ZREF", 'Fundraising Inc Report'[Source Code (Source Campaign)] ,, 0 ) &lt;&gt; 0 ||SEARCH("ZBAN", 'Fundraising Inc Report'[Source Code (Source Campaign)] ,, 0 ) &lt;&gt; 0 ||SEARCH("NAUG", 'Fundraising Inc Report'[Source Code (Source Campaign)] ,, 0 ) &lt;&gt; 0 ||SEARCH("AWAO", 'Fundraising Inc Report'[Source Code (Source Campaign)] ,, 0 ) &lt;&gt; 0 ||SEARCH("BUSR", 'Fundraising Inc Report'[Source Code (Source Campaign)] ,, 0 ) &lt;&gt; 0 ||SEARCH("AUGO", 'Fundraising Inc Report'[Source Code (Source Campaign)] ,, 0 ) &lt;&gt; 0 ||SEARCH("AV**", 'Fundraising Inc Report'[Source Code (Source Campaign)] ,, 0 ) &lt;&gt; 0), "Cash", &nbsp;IF('Fundraising Inc Report'[SOURCE_LETTER] = "0","000 Various", "MISC")))))))))))&nbsp;

ryan_mayu · Accepted Answer

Brookied&nbsp;
have you tried
IF(LEFT(SOUCECODE,1)="A" &amp;&amp; NOT SOURCECODE IN {"XXX","XXX","XXX"}&amp;&amp;LEFT(SOURCECODE,2)&lt;&gt;"AV", "01_CASH")

Forum Discussion

DAX help needed

2 Replies

Related content

DAX SOLUTION NEEDED

DAX assistance needed

Need help with DAX Formula

Need Help - DAX Code

need help for dax