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

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")
  • MartynRamsden's avatar
    MartynRamsden
    Solution Sage
    6 years ago

    Anonymous 

     

    Sorry, I missed a TRUNC() from the column name. It should have been:

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

     

    Most of the solutions suggested above would work in normal circumstances.

    If you still don't have any luck, please share you pbix so we can investigate further.

     

    Best regards,
    Martyn