Forum Discussion
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(VALUE...
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.