Latest date Power Query

[Anonymous]

am looking to see what i am doing wrong in the below query, i am trying to just pull values associated with the latest date that isnt blank;;

EVALUATE SUMMARIZECOLUMNS('Date'[Date], FILTER(VALUES('Date'[Date]), LASTNONBLANKVALUE('Date'[Date], "QTC Sales", [QTC Sales])

The error i am getting is saying Too few arguments were passed. 

Additional if i was going to try filter this to look at latest date per category would that be simple to add into the query

[Anonymous]

@amitchandak  thank you for the response, this is how it came out of SQL server manager in design mode. I am trying to just query the latest date rather than query all dates to limit the size of my dataset

[amitchandak]

@Anonymous , that you need to control using connection parameter 

https://community.powerbi.com/t5/Desktop/parameterize-connection/m-p/205900#M90712

[amitchandak]

@Anonymous , there many issues. The max I can get out of this is

EVALUATE SUMMARIZECOLUMNS('Date'[Date], "QTC Sales", LASTNONBLANKVALUE('Date'[Date],[QTC Sales]))

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.