Issue in applying If & Or function

[MayAnk__Rathi]

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.

[v-sgandrathi]

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.

[Omid_Motamedise]

Hi @MayAnk__Rathi 

use the following formula

let
    today = Date.From(DateTime.LocalNow()),
    value = [Column A],
    result = if value = today or value = Date.AddDays(today, -1) or value = Date.AddDays(today, 1) then "T" else "F"
in
    result

[slorin]

Hi @MayAnk__Rathi 

if Number.Abs(Number.From(Date.From(DateTime.LocalNow())-[ColumnA]))<=1 then "T" else "F"

Stéphane 

[abdelazizallam0]

let
Source = Excel.CurrentWorkbook(){[Name="Table1_2"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"date", type date}}),
#"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each let
today = Date.From(DateTime.LocalNow()),
yesterday = Date.AddDays(today, -1),
tomorrow = Date.AddDays(today, 1)
in
if [date] = today or [date] = yesterday or [date] = tomorrow then "T" else "F")
in
#"Added Custom"

[bhanu_gautam · Accepted solution]

@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]

yes, now formula is working.

Thanks 👍👍