Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Latest date Power Query

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