Using earlier with direct query (SQL)

[pras_hant10]

Hi Team,

I am trying to get the latest date from the table, based on created date time, which I was able to achive in table based data source, but same are getting failed when using the Direct Query. Below are the details:

MaxDate = CALCULATE(max(Reports1[created]),FILTER(Reports1,Reports1[ticker]=EARLIER(Reports1[ticker])))

LatestDate = If(Reports1[created]=[MaxDate],"Latest","Older")

Above formulas are not working with direct query data. Please suggest.

[amitchandak]

@pras_hant10 , You can not use earlier in case on direct query column

try a measure like

CALCULATE(max(Reports1[created]),FILTER(allselected(Reports1),Reports1[ticker]=max(Reports1[ticker])))

[pras_hant10]

I am unable to achive the same request, as in the blue area. While using new formula. (Measures)