Create a new column in query editor

[jalaomar]

Hi all,

I would like to create a new column with some conditions.

I have three Columns in my tabel, FI Local Account, Group Account & Cost type In which I want certain values for each column with the following data. In the Coumn FI Local Account I want to EXCLUDE the values. the output is to get the cost related to this filtering.

 could you please support with the type of DAX funtion I need to write in the query editor?

Thanks so much!!

• FI Local Account: !252465/54653800 Stlm COS Warranty, proj to COPA; !1590f01/55631100 Stlm COS Warranty, proj to COPA; !1540001/55641100 Stlm COS Warranty KC, proj to COPA; !1540001/73151000 Filling machine project warranty costs; !1540001/73351000 Processing equipment project warranty costs; !1590001/73361000 Processing key components project warranty costs; !1/79090010 Unabsorbed Tech Support exp (F187); !1590001/79200010 Issue Resolution CE-FM; !1570011/79200020 Issue Resolution CE; !252463/79200040 Service (SP/SE); !15400g1/79200050 Issue resolution Processing Systems COS

• Group Account: P11606021 PM Claims; P12101162 Issue resolution costs on PM; P12161422 Issue resolution Processing system COS; P12101432 Spare parts Issue resolution COS; P12101442 Issue resolution left in Technical service; P12101462 FM Issue resolution FM COS; P12101592 DE Issue resolution DE COS; P24205602 Write-down/write-up compensation & penalties provisions; P24205003 Write-down/Write-ups provisions Customer compensation and pe; P24205004 Write-down/Write-ups Other compensation & penalties provisi; P24250003; P24255002 Compensation and penalties costs; P24655003 Customer compensation/Penalties related to quality issues; P24256004 Other Compensations and Penalties costs

• Cost type: !Not assigned; !Issue Resolution TS (Unabsorbed)

[dax]

Hi jalaomar, 

If possible, could you please inform me more detailed information(such as your sample data and your expected output)? Then I will help you more correctly.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k]

@jalaomar it is very hard to follow your question. Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490