Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Indivual value instead of whole list

My Code:

 

let
Source = Excel.Workbook(File.Contents("C:\Users\B.Feichtlbauer\Documents\PowerBI_Test\ExportSelectedCmdbCis(2).xlsx"), null, true),
CMDB_Sheet = Source{[Item="CMDB",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(CMDB_Sheet, [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"CiGroup_Title", type text}, {"CiType_Title", type text}, {"CreatedAt", type datetime}, {"DeliveryDate", type any}, {"Description", type any}, {"EquipmentID", type any}, {"GWGID", type any}, {"Attributes_Overview", type any}, {"InvoiceNumber", type any}, {"LeasingCi", type logical}, {"LeasingComments", type any}, {"LeasingExpiration", type any}, {"LeasingReminder", Int64.Type}, {"LocationInformation", type any}, {"MiscellaneousInventory", type any}, {"PurchaseDate", type any}, {"PurchasePrice", type any}, {"Title", type text}, {"WarrantyUntil", type any}, {"Number_(String)", type text}, {"Person_Title", type text}, {"State", type text}, {"Asset_State", type text}, {"Server_Detail_Operating_System", type any}}),

#"search for MAC" = (list) =>
let

    Macs = List.Select(list, each List.Count(Text.Split(_, ".")) = 4 or List.Count(Text.Split(_, ":")) = 6),

    First = if Macs <> null then List.First(Macs) else "no MAC"

in
    

var = Table.SelectColumns(#"Promoted Headers", "Attributes_Overview" ),


#"Added Custom" = Table.AddColumn(#"Changed Type", {"MAC_Addresse"}, each #"search for MAC"(Text.Split(each var, "#(lf)"))),
    MAC_Addresse = #"Added Custom"{11}[MAC_Addresse]

in
MAC_Addresse

 

 I only need the indivual field of the column not the whole thing how can I change this?

1 ACCEPTED SOLUTION
KT_Bsmart2gethe
Impactful Individual
Impactful Individual

Hi @Anonymous , 

 

Was the other post you raised resolved?

 

To get a value from a particular row and column:

Syntax = TableName[ColumnName]{RowIndex}

 

Row index count from 0

 

Example:

KT_Bsmart2gethe_1-1657886326868.png

 

To get Alphabet E: 

Source[Column1]{4}

KT_Bsmart2gethe_2-1657886388228.png

 

Regards

KT

View solution in original post

2 REPLIES 2
KT_Bsmart2gethe
Impactful Individual
Impactful Individual

HI @Anonymous ,

 

Do you need to write M code to get something from CMDB?

What about you using the standard function from the toolbars?

 

Regards

KT

KT_Bsmart2gethe
Impactful Individual
Impactful Individual

Hi @Anonymous , 

 

Was the other post you raised resolved?

 

To get a value from a particular row and column:

Syntax = TableName[ColumnName]{RowIndex}

 

Row index count from 0

 

Example:

KT_Bsmart2gethe_1-1657886326868.png

 

To get Alphabet E: 

Source[Column1]{4}

KT_Bsmart2gethe_2-1657886388228.png

 

Regards

KT

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors