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"

v-sgandrathi's avatar
v-sgandrathi
Community Support
1 year ago

Hi MayAnk__Rathi,

 

Thank you bhanu_gautam for the response to the query.

 

I'm glad you found a solution and resloved  the query. Kindly mark the useful reply as the accepted solution so that others  in the community can find it quickly.

 

Thankyou for connecting with Microsoft Community Forum.