Forum Discussion

nmyre's avatar
nmyre
Icon for Helper III rankHelper 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.