Forum Discussion

klehar's avatar
klehar
Icon for Helper V rankHelper V
5 years ago
Solved

Trying to replace errors and replace values dynamically instead of entering static value

Hi,   I have a date called Lease Date. It has some errors and blanks   So I had used Replaced Errors and Replcaed Values functions from transformation in power query and replaced such values wit...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    klehar Another thought on this. ReplaceErrorValues but use a date like 12/30/2100. Add a conditional column and if that is the value, replace with your AddDays logic, otherwise, just use the existing date. Remove the original column and you are good.

klehar's avatar
klehar
Icon for Helper V rankHelper V
5 years ago

Greg_Deckler , this doesnt work, can you mock somethign up

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
5 years ago

klehar Another thought on this. ReplaceErrorValues but use a date like 12/30/2100. Add a conditional column and if that is the value, replace with your AddDays logic, otherwise, just use the existing date. Remove the original column and you are good.

  • klehar's avatar
    klehar
    Icon for Helper V rankHelper V
    5 years ago

    Greg_Deckler , Thats how it is already implemented currently. But my transformations already have a lot of steps slowing down the report. I;m trying to reduce every step I can

     

    • Greg_Deckler's avatar
      Greg_Deckler
      Icon for Community Champion rankCommunity Champion
      5 years ago

      klehar I totally understand. Real question on the performance front though is if the backend is something like SQL Server. If so, right-click your steps and see if you have Query Folding available. Move your steps around as possible so that as much of the query folds back into the backend as possible. That will have less processing taking place on your gateway and should boost performance in terms of refresh.