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

amitchandak's avatar
amitchandak
Super User
6 years ago

Your date might have timestamp

Is Today = if([date].date=Today(), "Yes", "No")

use .date

Appreciate your Kudos.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi,

 

Thanks for the response, it does not seem to like that:

 

  • MartynRamsden's avatar
    MartynRamsden
    Solution Sage
    6 years ago

    Hi Anonymous 

     

    Try this:

    Is Today = IF( Query2[new_ResolvedOn] = TRUNC( TODAY() ), "Yes", "No" )

     

    Best regards,
    Martyn

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      That did not work sorry, still getting the same issue, still not labelling correctly even when the dates are the same.

      • az38's avatar
        az38
        Community Champion
        6 years ago

        Hi Anonymous 

        try

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

        or the overcoded option

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