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
Greg_Deckler's avatar
Greg_Deckler
Community Champion
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