calculated column measure to show 1 when the date is one day less then todays date

[Anonymous]

Hi Experts

need a calculated column measure to show the value 1 when the date is one day less then the current date 
(See expected results in the table below)

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

It is for creating a new column.

Result CC =
VAR _condition =
    Data[Date]
        = TODAY () - 1
RETURN
    DIVIDE ( _condition, _condition, 0 )

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

It is for creating a new column.

Result CC =
VAR _condition =
    Data[Date]
        = TODAY () - 1
RETURN
    DIVIDE ( _condition, _condition, 0 )

[Anonymous]

HI Kim

how would you write the above calculated column as a measure??

[Jihwan_Kim · Accepted solution]

Hi,

One of ways to write a measure is as below.

expected outcome measure: = 
VAR _condition =
    SELECTEDVALUE(Data[Date])
        = TODAY () - 1
RETURN
IF( HASONEVALUE(Data[Date]),
    DIVIDE ( _condition, _condition, 0 )
)

[Mahesh0016]

New Column = if(date(today())<Table[Date],1,0)
@Anonymous Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!