Forum Discussion

steen_p's avatar
steen_p
Icon for Helper II rankHelper II
5 years ago
Solved

Get Value from Date table based on selected date

Hi,   I need a little input, on how to get a value from a table, based on another value.  I'm working on showing the number of contacts created in a given week and then also get the number form th...
Need Help
  • Icey's avatar
    Icey
    5 years ago

    Hi steen_p ,

     

    Try this:

    Today = TODAY()
    SelectedWeekID 2 =
IF (
    ISFILTERED ( 'Date'[Date] ),
    MAX ( 'Date'[WeekID] ),
    WEEKNUM ( [Today], 1 )
)

     

     

     

    Best Regards,

    Icey

     

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

  • steen_p's avatar
    steen_p
    Icon for Helper II rankHelper II
    5 years ago

    Hi amitchandak 

     

    Sorry for the late reply, but thanks for you reply. It seems like you are doing something along the line of what I've ben thinking :-).

    Do you also have an input, on how I can use todays date as "selection" for the date in case the user haven't selected anything?

     

    Regards

    Steen