Replace values with values in a different column RRS feed

  • Question

  • I have a few null values in column A " Month (End Date)" and Column B ("Year (End Date)" that I want to replace with values from Column C (Month ("Approved Date)") and Column D ("Year (Approved Date)"). In excel I just need to do an =formula and done but not sure how to code it in DAX to do this. Anyone knows the answer?

    Wednesday, April 24, 2019 10:48 PM


  • Is this a Power Query or a DAX (i.e. Power Pivot) question?

    To do this in PQ, you would write a custom formula something like this:

    = Table.ReplaceValue(PreviousStepName, null, each [#"Month (Approved Date)"], Replacer.ReplaceValue, {"Month (End Date)"})


    Thursday, April 25, 2019 12:23 AM