Forum Discussion
Anonymous
5 years agoNot applicable
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