I am loading an excel file which contains a week field and a phase field. I want to build a chart that uses a calculated expression where it uses the value of the phase for the latest week.
I need to find the function to use to retrieve the latest week from a table containing a few different dates. Example below. I tried using max(week) as [latest week] but get invalid expression error
Retrieving data ...