Forum Discussion

Jug's avatar
Jug
Frequent Visitor
3 years ago

Select rows with the most recent date without groupby

Hi, I would like to know if someone could help me with the following question:   I need to filter only the columns with the most recent date (and smaller than today, if possible), filtering the max...
Need Help
Jug's avatar
Jug
Frequent Visitor
3 years ago

I replaced all the field names with the real ones in the table correctly, the problem is that after the "IN" if I put only  #"Expanded Count" it does not work, I believe it needs to mention the table too

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
3 years ago

After in, you always have to specify the name of the last step.

  • Jug's avatar
    Jug
    Frequent Visitor
    3 years ago

    Unfortunately, it does not work because it has a group function and this is not supported with DirectQuery.