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"

Omid_Motamedise's avatar
Omid_Motamedise
Super User
1 year ago

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