User Profile
maneeshsinha
Regular Visitor
Joined 2 years ago
User Widgets
Contributions
PowerBI Advance Editor Error - Token Eof expected
Hi, I am getting an error message "Token Eof expected." while adding additional 'let' in an existing M function. Second screenshot is attached for reference. The first 'let' section is working perfectly fine (first screenshot is attached for reference). Getting an error only when adding an additional second 'let' statement. Please help. Thanks!! let Source = Excel.Workbook(File.Contents("C:\Users\SINHAM\OneDrive\MANEESH\DCS\1. BI Dashboard\PowerBI Dashboard\1. Latest-Version\1. FINAL\1. Dash\CMDB Baseline IP Subnet Ranges Expanded.xlsx"), null, true), #"CMDB IP Address_Sheet" = Source{[Item="CMDB IP Address",Kind="Sheet"]}[Data], #"Promoted Headers" = Table.PromoteHeaders(#"CMDB IP Address_Sheet", [PromoteAllScalars=true]), #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Environment", type text}, {"Subnet", type text}, {"Suffix", Int64.Type}}) in #"Changed Type" let Source = Excel.Workbook(File.Contents("C:\Users\SINHAM\OneDrive\MANEESH\DCS\1. BI Dashboard\PowerBI Dashboard\1. Latest-Version\1. FINAL\1. Dash\CMDB Baseline IP Subnet Ranges Expanded.xlsx"), null, true), IsIPInSubnet = (IPAddress as text, Subnet as text) => let SubnetAddress = Text.BeforeDelimiter(Subnet, "/"), SubnetMask = Text.AfterDelimiter(Subnet, "/"), SubnetBits = Text.ToNumber(SubnetMask), IPBinary = Binary.From(Number.FromText(Text.Combine(List.Transform(Text.Split(IPAddress, "."), each Text.PadStart(_, 3, "0")), ""))), SubnetBinary = Binary.From(Number.FromText(Text.Combine(List.Transform(Text.Split(SubnetAddress, "."), each Text.PadStart(_, 3, "0")), ""))), SubnetMaskBinary = Number.ToText(Binary.ToNumber(List.FirstN( Binary.ToList(Number.ToBinary(2^32 - 2^ (32 - SubnetBits))), 4))), Result = SubnetBinary = Binary.And(IPBinary, SubnetMaskBinary) in Result in IsIPInSubnet
