Forum Discussion
lawsonbe
Helper I
7 years agoFinding the most recent date from another table
I have two tables that deal with dates. One is a Date Table that contains a basic_date calculated column. This other table is an Instructional Date Calendar that contains all the days my school syste...
- 7 years ago
I finally gave up and created an additional column in the table and manually entered the data I needed. Ultimately the way I was thinking about the formula would only create data for a single year. I really wanted to have repeating values for each school year. Thanks for you the response.
v-chuncz-msft
Community Support
7 years ago
You may try using TOPN.
https://community.powerbi.com/t5/Desktop/Find-last-value-based-on-date/m-p/293150#M129228
- lawsonbe7 years ago
Helper I
I finally gave up and created an additional column in the table and manually entered the data I needed. Ultimately the way I was thinking about the formula would only create data for a single year. I really wanted to have repeating values for each school year. Thanks for you the response.