Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Power Query editor - make new column and change blank/empty EndDate cells in date TODAY

Hello community members,    I have the following issue. In the Power Query editor I have the following table below. Now I would like to have a new column that says: give date as stated in the colum...
Need Help
  • ntaylo06's avatar
    ntaylo06
    5 years ago

    In Power Query Editor use this formula in a custom column:

    if [EndDate] = null then DateTime.LocalNow() else [EndDate]

     

ntaylo06's avatar
ntaylo06
Resolver II
5 years ago

In Power Query Editor use this formula in a custom column:

if [EndDate] = null then DateTime.LocalNow() else [EndDate]

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    ntaylo06 Thank you for this quick and great help!