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

Need Help
Show and Tell

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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