Forum Discussion

nmyre's avatar
nmyre
Helper III
6 years ago
Solved

Creating a relationship with current date function "NOW()" to show the data for that day.

Hello,   My Goal: Make a visualization that shows todays date by creating a column using Get Date = NOW(). It should also show data for that day. Such as the Julian date, the % of the year that has...
Need Help
Tips and Tricks
  • v-lionel-msft's avatar
    v-lionel-msft
    6 years ago

    Hi nmyre ,

     

    Like this?

    Today = TODAY()
    Today_Visual = 
IF(
    'Table 2'[Date] = 'Table 2'[Today],
    'Table 2'[Date]
)

     

    Try to use TODAY() function instead of NOW() function.

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

Hi nmyre ,

 

Like this?

Today = TODAY()
Today_Visual = 
IF(
    'Table 2'[Date] = 'Table 2'[Today],
    'Table 2'[Date]
)

 

Try to use TODAY() function instead of NOW() function.

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • nmyre's avatar
    nmyre
    Helper III
    6 years ago

    v-lionel-msft 

     

    You crazy son of a gun, you did it! Makes so much sense now that I see it.

     

    Thanks so much!