Power Query formula to get the Today and Yesterday Sale values

Below formulas can be used to get only the Today and Yesterday Sale value in columns

Today Sale value:
TodaySale = if [Date]=  DateTime.Date(DateTime.LocalNow()) then [SaleValue] else null

Yesterday Sale value:
YesterdaySale = if [Date]=  Date.AddDays(DateTime.Date(DateTime.LocalNow()),-1) then [SaleValue] else null

Hope this will be helpful.