DAX formula where should I insert this?

Question

Hi,&nbsp;I have created in a previous report an extra column, with a formula, if I now check the formula it's:&nbsp;"Company", each if Text.Contains([SO nr], "BMB") then "BMB" else if Text.Contains([SO nr], "HER") then "HERENTALS" else if Text.Contains([SO nr], "HZ") then "HEUSDEN-ZOLDER" else if Text.Contains([SO nr], "EBAY") then "EBAY" else if Text.StartsWith([SO nr], "SO") then "WEBSITE SALES" else "to be defined")&nbsp;However if I add column in my new report, it gives an error, to not know why?Is there a difference between formula in the column area, and query area?&nbsp;RegardsDeborah

v-yulgu-msft · Accepted Answer

Hi&nbsp;Deborah1982,
&nbsp;
To add an extra column using DAX code in Report View mode, you could try below formula. Suppose the table name is 'Table1' and the new column is named as 'Company'.
Company&nbsp;=
IF&nbsp;(
&nbsp;&nbsp;&nbsp;&nbsp;NOT&nbsp;(&nbsp;ISERROR&nbsp;(&nbsp;SEARCH&nbsp;(&nbsp;"BMB",&nbsp;Table1[SO&nbsp;nr]&nbsp;)&nbsp;)&nbsp;),
&nbsp;&nbsp;&nbsp;&nbsp;"BMB",
&nbsp;&nbsp;&nbsp;&nbsp;IF&nbsp;(
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;NOT&nbsp;(&nbsp;ISERROR&nbsp;(&nbsp;SEARCH&nbsp;(&nbsp;"HER",&nbsp;Table1[SO&nbsp;nr]&nbsp;)&nbsp;)&nbsp;),
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"HERENTALS",
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;IF&nbsp;(
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;NOT&nbsp;(&nbsp;ISERROR&nbsp;(&nbsp;SEARCH&nbsp;(&nbsp;"HZ",&nbsp;Table1[SO&nbsp;nr]&nbsp;)&nbsp;)&nbsp;),
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"HEUSDEN-ZOLDER",
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;IF&nbsp;(
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;NOT&nbsp;(&nbsp;ISERROR&nbsp;(&nbsp;SEARCH&nbsp;(&nbsp;"EBAY",&nbsp;Table1[SO&nbsp;nr]&nbsp;)&nbsp;)&nbsp;),
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"EBAY",
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;IF&nbsp;(
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;NOT&nbsp;(&nbsp;ISERROR&nbsp;(&nbsp;SEARCH&nbsp;(&nbsp;"SO",&nbsp;Table1[SO&nbsp;nr]&nbsp;)&nbsp;)&nbsp;),
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"WEBSITE&nbsp;SALES",
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"to&nbsp;be&nbsp;defined"
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;)
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;)
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;)
&nbsp;&nbsp;&nbsp;&nbsp;)
)
Best regards,Yuliana Gu

Forum Discussion

DAX formula where should I insert this?

2 Replies

Related content

If formula

formula

DAX Formula Help

Issue in Inserting Formula in Table or Matrix View

Identity Insert On Warehouse table