Forum Discussion
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...
jtpiazzamn Try:
Month/Year Column = VAR __CreateDate = [Created date] VAR __Result = MAXX(FILTER('Date',[Date] = __CreateDate), [Start of Month]) RETURN __Result
hi jtpiazzamn
Greg's code does not rely on relationship. what issue did you encounter?
When I first started with a table
I then changed it to a bar chart
Then it worked - odd.