Forum Discussion

wahmed20's avatar
wahmed20
Icon for Resolver I rankResolver I
3 years ago
Solved

Assign yesterday date to a field in Filter rows

I have a date Field and I want to filter rows base on that In the Value , I want to have yesterday date formula. I used https://learn.microsoft.com/en-us/powerquery-m/datetime-fixedlocalnow i...
  • wahmed20's avatar
    3 years ago
    This worked for me 

     

     Date.From(DateTime.LocalNow() - #duration(1,0,0,0))