Forum Discussion

SanderBeukers's avatar
SanderBeukers
Icon for Advocate I rankAdvocate I
9 years ago
Solved

Limit query results by filtering a column with a MAX function

Hi All,   I'm working on a report which pulls data from a database which contains about 200K rows per monthly snapshot. The report only has to contain data from the latest monthly period (ergo: the...
Need Help
  • v-caliao-msft's avatar
    v-caliao-msft
    9 years ago

    SanderBeukers,

     

    Which databse are you connecting? If you use relational database, you can add this filter in your query.

     

    Besides, you could use the embedded filter to filter your date.

     

    Regards,

    Charlie Liao

v-caliao-msft's avatar
v-caliao-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

SanderBeukers,

 

Which databse are you connecting? If you use relational database, you can add this filter in your query.

 

Besides, you could use the embedded filter to filter your date.

 

Regards,

Charlie Liao

  • SanderBeukers's avatar
    SanderBeukers
    Icon for Advocate I rankAdvocate I
    9 years ago

    Thanks, i wasnt aware if this built in feature.