Forum Discussion

siva_powerbi's avatar
siva_powerbi
Icon for Helper IV rankHelper IV
5 years ago
Solved

Error at first value while using list.generate in power query

I am trying to extract the value from list and append data for each value in list in a loop.   Using list.Generator to achieve this task, problem I am facing here is for first value in list always ...
Need Help
Show and Tell
Tips and Tricks
  • CNENFRNL's avatar
    CNENFRNL
    5 years ago

    Hi, siva_powerbi , I think the glitch lies in here

    () => [i=0,x= Table.FromList(#"Col Names",Splitter.SplitByNothing)]

    try changing it to

    () => [i=0,x= Table.FromList(#"Col Names",Splitter.SplitByNothing())]
Anonymous's avatar
Anonymous
Not applicable
5 years ago

In Power Query, if your query has rows with data errors, you can remove these rows from your query. Data errors can occur as a result of a query or step evaluation, such as changing the type of a column to Number that results in errors for some cells.

Power Query if Statements
  1. The 'if' in Power Query is lower case.
  2. Instead of commas separating the value_iaf_true and value_if_false arguments we have the words then and else (in lower case).
  3. null means blank in Power Query.
  4. Power Query formulas are case sensitive.