Hello all.
I'm actually newbie to PowerBi so I apologize if I make any silly mistake.
I'm currently handling with a source table that must be updated every week and may vary its number of columns.
The source data works like this: there are a handful of event types that may occur every week. The source data have a column for each eventy type but it will only contain the events that happend that week.
For example, imagine there are the following type of events: "Event A", "Event B", "Event C" and "Event D".
Now imagine that in the past week only the Event A and Event C occurred, so my source data wouldn't have the columns "Event B" and "Event D".
Now if I try to update the report with the source data for the last week I will get the error "Missing Field" in some steps. I tried to add the MissingField.Ignore argument in the Table.ReplaceValue function like this:
#"Replaced Value" = Table.ReplaceValue(#"Promoted Headers","0000-00-00","1900-01-01",Replacer.ReplaceText,{"FdtLast58_1", "FdtLast58_2", "FdtLast58_3", "FdtLast58_4", "FdtLast58_5", "FdtLast58_32", "FdtLast58_42", "FdtLast58_47", "FdtLast58_247"},MissingField.Ignore)
But now I get the error "Expression.Error: 6 arguments were passed to a function which expects 5." like if wasn't supposed to use MissinfField.Ignore that way. Am I doing something wrong?
