Forum Discussion

MayAnk__Rathi's avatar
MayAnk__Rathi
Helper I
1 year ago
Solved

Issue in applying If & Or function

I face issue in implementing a formula in power query Formula is: If date in Column A is equal to today's date or yesterday's date or tomorrow's date then result is T else F. Please guide me.
Need Help
  • bhanu_gautam's avatar
    bhanu_gautam
    1 year ago

    MayAnk__Rathi Open your Power Query editor.
    Add a new custom column.
    Use the following formula in the custom column:

    let
    Today = Date.From(DateTime.LocalNow()),
    Yesterday = Date.AddDays(Today, -1),
    Tomorrow = Date.AddDays(Today, 1)
    in
    if [ColumnA] = Today or [ColumnA] = Yesterday or [ColumnA] = Tomorrow then "T" else "F"

bhanu_gautam's avatar
bhanu_gautam
Super User
1 year ago

MayAnk__Rathi Open your Power Query editor.
Add a new custom column.
Use the following formula in the custom column:

let
Today = Date.From(DateTime.LocalNow()),
Yesterday = Date.AddDays(Today, -1),
Tomorrow = Date.AddDays(Today, 1)
in
if [ColumnA] = Today or [ColumnA] = Yesterday or [ColumnA] = Tomorrow then "T" else "F"

  • MayAnk__Rathi's avatar
    MayAnk__Rathi
    Helper I
    1 year ago

    yes, now formula is working.

     

    Thanks 👍👍