Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Is Today Column

Hi,   I am trying to create a column called Is Today and it isn't pulling through the correct answer on the if query:   Is Today = if([date]=Today(), "Yes", "No")   It is only pulling through t...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    6 years ago

    hi   Anonymous 

    For your case, that must be that your [Date] column has the different "time" in the same date. or it is a datetime column in edit queries but you just change the datatype in power bi.

    For example:

    So just use DATE Function to nested in the formula as below:

    https://docs.microsoft.com/en-us/dax/date-function-dax

    New Is Today = if(DATE(YEAR([date]), MONTH([date]), DAY([date])) = Today(), "Yes", "No")

    Result:

     

    Regards,

    Lin

v-lili6-msft's avatar
v-lili6-msft
Community Support
6 years ago

hi   Anonymous 

For your case, that must be that your [Date] column has the different "time" in the same date. or it is a datetime column in edit queries but you just change the datatype in power bi.

For example:

So just use DATE Function to nested in the formula as below:

https://docs.microsoft.com/en-us/dax/date-function-dax

New Is Today = if(DATE(YEAR([date]), MONTH([date]), DAY([date])) = Today(), "Yes", "No")

Result:

 

Regards,

Lin