Create a new column in query editor

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)