Forum Discussion

jtpiazzamn's avatar
jtpiazzamn
Helper I
3 years ago
Solved

retrieve value from date table based on date in current table

Date table has the following fields: (Date field lists each day in the year) Date Start of Month   1-1-2023 1-1-2023   1-2-2023 1-1-2023   3-1-2023 3-1-2023     Members tabl...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    jtpiazzamn Try:

    Month/Year Column =
  VAR __CreateDate = [Created date]
  VAR __Result = MAXX(FILTER('Date',[Date] = __CreateDate), [Start of Month])
RETURN
  __Result
jtpiazzamn's avatar
jtpiazzamn
Helper I
3 years ago

Thank you - I forgot to mention that the relationship between the Date Table and the Members Table is "inactive".

FreemanZ's avatar
FreemanZ
Super User
3 years ago

hi jtpiazzamn 

Greg's code does not rely on relationship. what issue did you encounter?

  • jtpiazzamn's avatar
    jtpiazzamn
    Helper I
    3 years ago

    It appears to be ok. I thought it was relevant. 
    I have another question though. When I go to use this column (formatted as Date), when using it in a chart, it reads it as a count only - can't display the value of the date in the column. 

     

    I'm confused. 

    Thank you for helping!

     

    Jim

     

     
  • jtpiazzamn's avatar
    jtpiazzamn
    Helper I
    3 years ago

    When I first started with a table 

     

    I then changed it to a bar chart 

    Then it worked - odd.