M Query problem

[Anonymous]

Hi guys,

I have been developing a dashboard, and so far there are no issues with it but when I try to replace/update the data source, I get an error that says 

Expression.Error: There weren't enough elements in the enumeration to complete the operation
Details:

Table

I checked the Query editor and from what I saw the source has been loaded just fine but the error appears at the "Replace value" step

I checked the M Query and and this appeared:

let
    Source = #"Central (FLO)",
    #"Removed Columns" = Table.RemoveColumns(Source,{"Cost Allocation", "Description", "Resource", "Text", "Vendor", "adar", "Period", "Year", "Accounting date", "Concept", "Concept description", "Category", "Doc.Header Text", "Explanation", "Reference"}),
    #"Filtered Rows" = Table.SelectRows(#"Removed Columns", each ([adar1] = "Equipment" or [adar1] = "Plant and material" or [adar1] = "Subcontractor")),
    #"Pivoted Column" = Table.Pivot(#"Filtered Rows", List.Distinct(#"Filtered Rows"[#"Company Name"]), "Company Name", "Company code amount", List.Sum),
    #"Replaced Value" = Table.ReplaceValue(#"Pivoted Column",null,0,Replacer.ReplaceValue,{"AECOM Ltd", "PARAGON GROUP UK LIMITED", "LAING O´ROURKE CONTRUCTION LTD", "VVB ENGINEERING LTD", "ARES SOFTWARE UK LTD", "FELLOWS INTERNATIONAL LIMITED", "G4S SECURITY SERVICES LTD", "MALCOLM HOLLIS LLP", "PORT OF LONDON AUTHORITY LIMIT", "CNLR HORIZONS LIMITED", "Duradiamond Healthcare", "Structural Soils Limited", "CreativeConnection Consultants", "TSC Signs Ltd", "EUGENE HARRINGTON MARKETING LT", "ENRO SUPPLIERS LTD", "ANFOLD SOFTWARE LTD", "SCCS (PAUL MACARTHUR LTD)", "TRUSTID LIMITED", "BUNZL UK LIMITED", "HENNY LIMITED", "NFM TECHNOLOGIES", "WFL (UK) LTD", "DANNY SULLIVAN & SONS LTD", "Specialist Construction Suppli", "ARCO LTD", "BRETT AGGREGATES LTD", "OFFICE DEPOT INTERNATIONAL (UK", "WHITE HART CARW GWYN LIMITED", "L LYNCH(PLANT HIRE & HAULAGE)", "ASHTEAD PLANT HIRE COMPANY LIM", "JDM Merchandise Ltd", "POWERDAY", "Regional Waste Recycling Ltd", "Scott Parnell Ltd", "Thurrock Engineering Supplies", "VISION SURVEY LIMITED", "VP PLC", "williams environmental managem", "ASITE SOLUTIONS LTD", "Bramley Engineering LTD", "EXPANDED LTD", "MARINE AND RISK CONSULTANTS LI", "SELECT PLANT HIRE", "West Netherton Engineering Ser", "UGLAND SHIPPING AS", "ATKINS LIMITED", "THOMAS COOPER LLP", "MARINE & TOWAGE SERVICES GROUP", "H. SIVYER TRANSPORT LIMITED", "DIRECT WELDING & SITE SUPPLIES", "TAYLOR CONSTRUCTION PLANT LIMI", "FIRWOOD TIMBER & PLYWOOD CO. L", "FULHAM TIMBER MERCHANTS LIMITE", "BAM Nuttall Ltd", "VOLKERSTEVIN LIMITED", "BLUE ARROW TRAFFIC MANAGEMENT", "BT Payment Services Ltd", "CMT Equipment Ltd", "GAP Group", "J. MURPHY & SONS LIMITED", "P FLANNERY PLAN HIRE (OVAL)", "SELKENT FASTENINGS LTD", "SHEET PILING (UK)", "SIG TRADING LTD", "Slater Signs", "WJ GROUNDWATER LTD", "PRECON PRODUCTS LTD", "Dragados Sisk Joint Venture", "Euro Fire Protection&Maintenan", "HYDRO CLEANSING LIMITED", "KINGS ROAD DAIRY LIMITED", "ROPE & MARINE SERVICES LTD", "STATEX LIMITED", "SVANTEK UK LTD", "WATERLIFE LTD", "BARHALE PLC", "BECKETT RANKINE LIMITED", "GARDINER & THEOBALD LLP", "GEOCISA UK LIMITED", "Hanson Quarry Products Europe", "PERI LTD", "RNP ASSOCIATES LIMITED", "SOCOTEC UK LIMITED", "WENTWORTH HOUSE PARTNERSHIP", "WHITE'S TRANSPORT LIMITED", "ADEC Marine Ltd", "CET STRUCTURES LTD", "J.H. (LIFTING GEAR HIRE) LIMIT", "ALEX BIRGER GRIEG AS", "CAMFAUD CONCRETE PUMPS LIMITED", "HILTI (GB) LTD", "LONDON OFFSHORE CONSULTANTS LT", "TURNKEY INSTRUMENTS LIMITED", "HR WALLINGFORD LIMITED", "PODFATHER LTD", "CONQUIP ENGINEERING GROUP", "ASHBY & CROFT LTD", "Express Reinforcements Ltd", "AIR POWER PRODUCTS LIMITED", "E.T.S. PORTSMOUTH LIMITED", "EDMUNDSON ELECTRICAL LTD", "HIRESTATION", "RAINHAM STEEL CO LIMITED", "REXEL UK LIMITED", "ACTAVO (UK) LIMITED", "COMBISAFE INTERNATIONAL LTD", "FLUTE OFFICE LIMITED", "GPS MARINE CONTRACTORS LIMITED", "ROSEGLIDE LIMITED", "D-S B OFFSHORE LIMITED", "ROBERT BIRD & PARTNERS LIMITED", "CHARLES WILSON ENGINEERS LIMIT", "KNOWLEDGE WAREHOUSE LTD", "ACOUNA LIMITED", "RIWAL UK LTD", "IMAGE 2 LIMITED", "DAM STRUCTURES", "F.P. MC CANN, LTD.", "WOLSELEY UK LTD", "GEOSEA LUXEMBOURG SA", "JOHN COUPLAND ASSOCIATES", "McAllister Bros Ltd", "ORDTEK LTD", "THAMES WATER UTILITIES LTD", "BLACKLEY ELECTRICS LIMITED", "ASSOCIATED POLYMER SERVICES LT", "HADEE ENGINEERING CO LTD", "MCGRATH BROS. (WASTE CONTROL)", "RMD KWIKFORM LTD", "AMEY UTILITY SERVICES LIMITED", "BELL JOHNSON LIMITED", "BURTON & SMITH MOVING LTD", "Neptune Equipment BV", "PARSONS BRINCKERHOFF LTD", "LANDFALL MARINE CONTRACTORS", "NRG SURVEYS LTD", "CRT IMAGERY LIMITED", "THAMES21 LIMITED", "BRIDGE THE GAP CAFE LTD", "CHANGING PATHS CIC", "HEWDEN STUART LTD", "REACTEC LIMITED", "SETON (BRADY CORP. LTD.)", "CVU", "EURO DIAMOND DRILLING LTD", "GRISTWOOD AND TOMS LTD", "JT PUMPS LIMITED", "CHEVAL DESIGN LTD", "GEMINI PRINT SOUTHERN LIMITED", "HOBS STUDIO LIMITED", "PALISADE EUROPE UK LTD", "SARENS BE", "J HOME IMPROVEMENTS LTD", "MAXWELL GEOSYSTEMS UK LTD", "ONE AVENUE JEWRY LIMITED", "PARK RETAIL LIMITED", "INDUSTRIAS ELECTROMECANICAS GH", "E.G.SHEPPARD MOSCOW LLP", "CONSIDERATE CONSTRUCTORS SCHEM", "SENESAEL DANIEL & ZOON BVBA", "PUMP SUPPLIES LTD", "TfL – Surface  Transport", "TRAVIS PERKINS PLC", "V J TECHNOLOGY", "KIRSI MARITA PYY", "OTB ENGINEERING LIMITED", "RENDEL LIMITED", "ROBERT WEST CONSULTING LTD", "VIRGINIA MAIR CHAPPEL", "SALIX RIVER & WETLAND SERVICES", "PRESSON LIMITED", "Dynasafe BACTEC Limited", "FUGRO GEOSERVICES LTD", "BUREAU VERITAS", "EVENT COMMUNICATIONS SERVICES", "LAND & ANCHOR LTD", "LITTLEWOOD FENCING LIMITED", "ORACLE CORPORATION UK LTD", "CLEVELAND CABLE COMPANY LIMITE", "MARK HALE", "TIMOTHY JOHN EPPS", "CAPITAL PLEASURE BOATS LIMITED", "TONY RIDLEY HYPERBARIC ASSOCI", "Emerson Crane Hire Ltd", "THE FRANKING MACHINE COMPANY", "WARD SECURITY (LONDON) LIMITED", "AIKEN GROUP LIMITED", "ALCUMUS INFO EXCHANGE LTD", "KEYLINE BUILDERS MERCHANT LIMI", "VOLKERBROOKS LIMITED", "APP LIFTING SERVICES LIMITED", "DAWSON CONSTRUCTION PLANT LTD", "GALVEN LIMITED", "AECOM Infrastructure & Environ", "CITYSPRINT (UK) LTD.", "CLEVELAND STEEL & TUBES LTD", "BUREU VERITAS MARINE & OFFSHOR", "OVE ARUP & PARTNERS LTD", "THAMES SKILLS ACADEMY LIMITED", "BLUE BAY BUILDING PRODUCTS LIM", "FENDER CARE LIMITED", "H MCGOVERN SON PLANT HIRE LTD", "PORT OF TILBURY LONDON LIMITED", "RENTOKIL INITIAL UK", "SARA DEANE", "ACONEX (UK) LIMITED", "COMBIFLOAT SYSTEMS BV", "DAMEN SHIPYARDS GORINCHEM", "ELESS DECOMMISSIONING SERVICES", "TYNE GANGWAY (STRUCTURES) LIMI", "ALBANY ENVIRONMENTAL SERVICES", "ATLAS WINCH & HOIST SERVICES L", "BETA DISTRIBUTION (SOUTH) LTD", "E. COLEMAN & CO. LIMITED", "GALLDRIS CONSTRUCTION", "GARIC LTD", "HOARE LEA LLP", "I&C LIMITED", "JAMES FISHER MARINE SERVICES L", "PILING & WELDING CONSTRUCTION", "READMAN STEEL LIMITED", "RICHTER ASSOCIATES", "RUTHERFORD GLOBAL POWER", "SIAN FORMWORK LIMITED", "TCI (GB) LTD", "WATSON & HILLHOUSE LIMITED", "WELDEX (INTERNATIONAL) OFFSHOR", "HART MARINE SERVICES", "JACKUP GB LTD", "TEAM INGENIERIA CONSULTORIA, S", "TECHFINIUM LIMITED", "BUILDING RESEARCH ESTABLISHMEN", "The Colour Red Limited", "AIR PRODUCTS PLC", "PROES CONSULTORES, S.A.", "ARCELORMITTAL COMMERCIAL RPS", "BILLI (UK) LLP", "GENERIC SUPPLIER GB", "STRUCTURAL & WELD TESTING SERV", "B & B INDUSTRIAL DISMANTLING L", "CORBETT & SONS LIMITED", "MABEY HIRE LIMITED", "ANKER SCHROEDER ASDO GMBH", "CEMEX UK OPERATIONS LIMITED", "THISTLE STEEL INTERNATIONAL LT", "KILNBRIDGE CONSTRUCTION SERVIC", "TEMPORARY WORKS DESIGN UK LTD", "CEMEX UK OPERATIONS LTD", "NRC Plant Ltd", "FORD RETAIL LTD T/AS TRUSTFORD", "SARUM HARDWOOD STRUCTURES LTD", "ASD LIMITED", "AYESA LTD.", "BENTLEY SYSTEMS UK LTD", "CDM SURVEYS LIMITED", "SCHAUENBURG TECHNICAL SOLUTION", "S&H WELDING SERVICES", "BBMV JV C510", "FINE MESH METALS LIMITED", "HENSHALL & SHEEHY SUPPORT SERV", "PACADAR U.K. LIMITED", "ROBERT STEVENS & SONS LIMITED", "COASTAL TRANSIT SERVICES", "JP CONCRETE PRODUCTS LIMITED", "BPH EQUIPMENT LIMITED", "SILTBUSTER LTD", "WHEELWASH LIMITED", "WILLIAMS SHIPPING MARINE LTD", "AGGREKO UK LIMITED", "Specialist Plant Associates", "CLASSIC LIFTS LIMITED", "DYWIDAG SYSTEMS INTERNATIONAL", "GAMMA BUSINESS COMMUNICATIONS", "IMPERATIVE TRAINING LTD", "KELTBRAY ENVIRONMENTAL LTD", "LIEBHERR - GREAT BRITAIN LTD", "TYLER SECURITY LIMITED", "WATERCOOLERS DIRECT.COM LTD", "ALAN AULD ENGINEERING LTD", "SPECIALIST PLANT ASSOCIATES", "RVT GROUP LIMITED", "AGGREGATE INDUSTRIES UK LIMITE", "FM Conway Limited", "GRAMM BARRIER SYSTEMS LTD", "JOY GLOBAL (UK) LIMITED", "CPM SURVEYS LTD", "ANCHOR BAY CONSTRUCTION PRODUC", "AMALGAMATED LTD", "CHAPMAN STEELWORK FABRICATION", "CRISTEC SECURITY DESIGNS LTD", "G.G.R. GROUP LTD", "GPSM DIVECO LTD", "ICL SOLUTIONS LIMITED", "MABEY BRIDGE", "THOMPSON WELDING & CONSTRUCTIO", "BRAND ENERGY & INFRASTRUCTURE", "FARRER & CO LLP", "JHON F HUNT DEMOLITION LTD", "Keller Ltd", "LIFTING PROJECTS UK  LTD", "LIVERPOOL GLASGOW SALVAGE ASSO", "MCGEE GROUP (HOLDINGS) LIMITED", "RORCON LTD", "WILDE ANALYSIS LIMITED", "ABI EQUIPMENT LIMITED", "XEROX UK LTD", "NPOWER DIRECT LIMITED", "ALLTASK LIMITED", "PROSERVE LIMITED", "COLLINS WATERAGE & LIGHTER", "CITY OF LONDON", "Hydrainer Pump Hire Ltd", "LANESFIELD ENGINEERING SEALS L", "POWER SYSTEM SERVICES LIMITED", "Abnormal Load Engineering Ltd", "DUNSMORE CONSULTANCY LIMITED", "INGREBOURNE VALLEY LIMITED", "HANNING LIMITED", "RIPPLESIDE METAL WORKS LTD", "2ORDER GROUP LIMITED", "PINNACLE RESPONSE LTD", "PLARAD UK LTD", "RHICON PILING LIMITED", "SCHOMA CHRISTOPH SCHOTTLER MAS", "SELECTAGLAZE LIMITED", "HOARD-IT LIMITED", "JOSEPH GALLAGHER LIMITED", "PROTECHNING LIMITED", "CHAS. NEWENS MARINE CO. LIMITE", "EXPLORE TRANSPORT LIMITED", "Speedy Asset Services Ltd", "COOL INSTALLS LTD", "HARVEY CRANE & PLANT LTD", "GLOBAL ASSET MANAGEMENT PARTNE", "HI-PRESS HYDRAULICS LIMITED", "WM PLANT HIRE LIMITED", "VEOLIA ES (UK) LIMITED", "Geoline Ltd", "GROUTATION LTD", "GECKO INNOVATIONSL LTD", "EXPLORE MANUFACTURING LIMITED", "JOHN NIXON LTD", "TTC BUILDING SERVICES LTD", "MANE CONTRACTS SERVICES LTD", "McGinley Support Services (Inf", "RPC CONTRACTS LIMITED", "STUDWELDPRO - U.K. LIMITED", "MCCALLS SPECIAL PRODUCTS LIMIT", "MORELLO GIOVANNI S.R.L.", "CHUBB ELECTRONIC SECURITY", "IMPACT (BREAKERS & ATTACHMENTS", "SARENS (UK) LTD", "BOULTING GROUP LIMITED", "CMP THAMES LIMITED", "FAIRHURST", "HAM BAKER ADAMS LIMITED", "LAND & WATER SERVICES LTD", "LIVETT'S LAUNCHES LIMITED", "TRANSFORGE (UK) LTD", "CRH FENCING & SECURITY GROUP", "ECOFFICIENCY LIMITED", "LAND & WATER PLANT LIMITED", "PRESSVESS (INTERNATIONAL) LTD", "TRAD SCAFFOLDING CO. LIMITED", "DRILLSERVE LIMITED", "McGinley Support Services", "HERRENKNECHT AG", "MODULAR JACKUP BARGE OPERATION", "RIDGEWAY PLANT CO LIMITED", "SIMEM Underground Solutions In", "ELECOSOFT UK LTD", "EPIROC UK AND IRELAND LIMITED", "HDM TUBES LIMITED", "PBE RUTHERFORD LIMITED", "CASTLE WATER LIMITED", "ELLIS OFFSHORE LIMITED", "GLOBAL PROJECT (SERVICES) LIMI", "FERROVIAL AGROMAN UK LIMITED", "PRESSVESS ENGINEERING LTD", "JENKINS MARINE LTD", "TEIGNMOUTH MARITIME SERVICES L", "ERG (AIR POLLUTION CONTROL) LT", "COLLINS RIVER ENTERPRISES LIMI", "DUNFORD MARINE CONSULTANTS LIM", "IMPERIAL WHARF MARINA LIMITED", "DEW PILING LIMITED", "HIGH VALUE SYSTEMS ENGINEERING", "KARL-H.MÜHLHÄUSER GMBH&CO.KG", "Reliable Contractors Limited", "RENTAJET GROUP LIMITED", "ROBERT WALPOLE AND PARTNERS", "DARCY PRODUCTS LTD", "THAMES MARINE SERVICES LIMITED", "PROFESSIONAL LIFTING SERVICES", "KAYATI, S.L.", "NIXON FARROW LIMITED", "VOLKERHIGHWAYS LIMITED", "PBE EUROPE LIMITED", "PENINSULAR LOGISTICS LIMITED", "PUMP PARTS LIMITED", "RUL, S.L.", "HAM BAKER LIMITED", "CBE GROUP", "LIFTING GEAR HIRE LIMITED", "NEPTUNE MARINE SERVICE B.V.", "AQUA COOLING SOLUTIONS LIMITED", "GALLDRIS SERVICES LTD", "THE OFFICE GROUP PROPERTIES LT", "TAG CONSTRUCTION LIMITED", " EJ COVERS ", "MAPEI (UK) LIMITED", "SPRINT ENGINEERING & LUBRICANT", "ARCELORMITTAL COMMERCIAL UK LT", "AUTO-MATE SYSTEMS LIMITED", "ARCLIGHT EAST LTD", "OGI GROUNDWATER SPECIALISTS", "BURROWS BROTHERS (SALES) LIMIT", "FUGRO GB (NORTH) MARINE LIMITE", "YESSS (A) ELECTRICAL LTD", "PREMIER CARRIERS LTD", "ERG (Ventilation)", "ENVIROMONTEL LIMITED", "its testing services", "KELTBRAY LIMITED", "TIME MANAGEMENT POLICY LIMITED", "AXLE HAULAGE LIMITED", "KELLY BROS SOLAR SIGNS LIMITED", "NV DEMAECKER EN VAN HAECKE", "TECHNICAL TUNNELLING COMPONENT", "UK SCREED & GROUT PUMPS LIMITE", "HBPW LLPv", "PIRTEK (UK) LIMITED", "SAFER FOOD SCORES LIMITED", "EDF ENERGY CUSTOMERS LIMITED", "POWERRUN HOLDINGS LIMITED", "SOFA.COM LTD", "STUDIO INDIGO LIMITED", "BURROWS CONVEYOR SYSTEMS LIMIT", "CADOGAN PIER LIMITED", "SAFELANE GLOBAL (GILLINGHAM) L", "PALMIERI S.P.A.", "BRILLIANT IDEAS LTD", "VOESTALPINE RAIL CENTER DUISBU", "ACTIVE TUNNELLING LIMITED", "HERGON METROPOLITAN UK LIMITED", "MJ Chapman Photography", "MACROMIN LIMITED", "SUMINISTRO HIDRAULICOS TECNICO", "TARMAC CEMENT AND LIME LIMITED", "FALCO CONSTRUCTION LIMITED", "ARCELORMITTAL KENT WIRE LTD", "AURORA COMPUTER SERVICES LIMIT", "CONDAT S.A.", "FIBREGRID LIMITED", "SOUTHDOWNS", "TIDEWAY", "CB HEATING LTD", "MENTAL HEALTH FIRST AID ENGLAN", "NMT CRANE HIRE LIMITED", "VEOLIA ES LANDFILL LIMITED", "VRAKKING B.V. EN H. VRAKKING B", "POLTINGER PRECISION SYTEM GMBH", "M. O'BRIEN (PLANT HIRE) LTD.", "CORDEK  LIMITED", "F.R. BARTON & SON LIMITED", "NORMET UK LIMITED", "TREES FOR CITIES", "VMT GMBH", "SPOOR-TECH LTD", "TALLERES ZITRON, S.A.", "Tideway", "G T LIFTING SOLUTIONS LIMITED", "SCREWFAST FOUNDATIONS LIMITED", "HBC RADIOMATIC (UK) LIMITED", "CERTAS ENERGY UK LIMITED", "BATT CABLES PUBLIC LIMITED COM", "TUNNELLING ACCESSORIES LTD", "MARKHAM (SHEFFIELD) LIMITED", "ATI TANK HIRE LIMITED", "MACCAFERRI LTD", "BRANDON HIRE STATION", "OASYS LIMITED", "DR DANIEL LEON BORIN !! GEOSOL", "BRIGGS EQUIPMENT UK LIMITED", "AFFABLE PILING CO. LTD", "SULZER PUMPS WASTEWATER SPAIN", "PW HIRE LIMITED", "EUROFLO FLUID HANDLING LIMITED", "EMTEC LABORATORIES LIMITED", "CMJ CRANE SERVICES LTD", "XCELL MISTING LIMITED", "BASF PUBLIC LIMITED COMPANY", "ATLAS COPCO LIMITED", "WURTH UK LIMITED", "CITY LIFTING LTD", "ALTHON LIMITED", "INFLO SYSTEMS LTD", "DR. SAUER AND PARTNERS LT", "SAINT-GOBAIN CONSTRUCTION PROD", "UNITSPARK LIMITED"}),
    #"Unpivoted Columns" = Table.UnpivotOtherColumns(#"Replaced Value", {"AfP Month", "Type", "adar1"}, "Attribute", "Value"),
    #"Renamed Columns" = Table.RenameColumns(#"Unpivoted Columns",{{"Attribute", "Company Name"}, {"Value", "Company code amount"}}),
    #"Sorted Rows" = Table.Sort(#"Renamed Columns",{{"Company Name", Order.Ascending}, {"AfP Month", Order.Ascending}})
in
    #"Sorted Rows"

I suspect the error pops up because the "Replace value" line specifically lists the values under these specific columns that needed to be replaced. When I update the data these specific columns may or may not be there, and there may be values that come up that is not included in the list.

Can I revise this line in a way that would send an order to replace cell values to every columns except some specific ones? For this problem I want to replace all values from every columns except for columns "Type", "AfP Month", and "adar1"

Thanks for the help

[Anonymous · Accepted solution]

I found the solution from a reddit post:

To arrive at the intended outcome you'll make use of variables as shown in the screenshot:

Here is the resulting M query in my dashboard:

let
    Source = #"Central (FLO)",
    #"Removed Columns" = Table.RemoveColumns(Source,{"Cost Allocation", "Description", "Resource", "Text", "Vendor", "adar", "Period", "Year", "Accounting date", "Concept", "Concept description", "Category", "Doc.Header Text", "Explanation", "Reference"}),
    #"Filtered Rows" = Table.SelectRows(#"Removed Columns", each ([adar1] = "Equipment" or [adar1] = "Plant and material" or [adar1] = "Subcontractor")),
    #"Pivoted Column" = Table.Pivot(#"Filtered Rows", List.Distinct(#"Filtered Rows"[#"Company Name"]), "Company Name", "Company code amount", List.Sum),
    ColumnNames = Table.ColumnNames(#"Pivoted Column"),
    FilteredList = List.RemoveItems(ColumnNames, {"AfP Month","Type","adar1"}),
    #"Replaced Value" = Table.ReplaceValue(#"Pivoted Column",null,0,Replacer.ReplaceValue,FilteredList),
    #"Unpivoted Columns" = Table.UnpivotOtherColumns(#"Replaced Value", {"AfP Month", "Type", "adar1"}, "Attribute", "Value"),
    #"Renamed Columns" = Table.RenameColumns(#"Unpivoted Columns",{{"Attribute", "Company Name"}, {"Value", "Company code amount"}}),
    #"Sorted Rows" = Table.Sort(#"Renamed Columns",{{"Company Name", Order.Ascending}, {"AfP Month", Order.Ascending}})
in
    #"Sorted Rows"

Hope this helps to everyone having the same problem as mine.

[Mariusz]

Hi @Anonymous 

May I ask a question, what is the reason for Pivoting, Replacing Values and Unpivoting?

Best Regards,
Mariusz

Please feel free to connect with me.

[Anonymous]

Hi @Mariusz ,

I need to pivot and replace my values in order for some of my measure to work. My intention for pivoting and replacing values is to show the periods when each parameter/company name has a value of zero in the calculated table. My measure will not work without this method

[Mariusz]

Hi @Anonymous 

By pivoting the company name you are creating approximately 500 columns ( not the best for performance ), the error that you see is probably caused by one of them missing and this will happen every time there is a change in the data set.

The solution here is to replace this steps, but keep the same result.

If you can create a small sample of data, one for before transformation and second for the desired outcom, I'm sure I can work somthing out.

Best Regards,
Mariusz

Please feel free to connect with me.