Forum Discussion

mddistributor1's avatar
mddistributor1
Regular Visitor
4 years ago

Power Query - Data manipulation

I have data setup like the below table. Every time something is received the system creates a dash that is one higher than the prior one which shows everything that is yet to be received. I'm trying ...
Need Help
CNENFRNL's avatar
CNENFRNL
Community Champion
4 years ago

Wierd to use PQ to solve such a question whereas DAX is designed to come into play in such a scenario. A DAX solution is way more concise and elegant.

 

For fun only, showcase of powerful worksheet formula,

  • mddistributor1's avatar
    mddistributor1
    Regular Visitor
    4 years ago

    This is an awesome setup. I wouldn't have come up with that. Do you have any way to get that extra date in there? Because June doesn't have anything showing for backorders even though there was $300 in backorders that month. This was originally why I was thinking power query because I wanted the actual data to have something for each date. If that is possible in DAX I'd love to know how to do it. 

    • CNENFRNL's avatar
      CNENFRNL
      Community Champion
      4 years ago

      A seemly rookie question but, in fact, fairly tricky.

      • mddistributor1's avatar
        mddistributor1
        Regular Visitor
        4 years ago

        Now, here is the question. How do you aggregate this for all POs? Because I do want to be able to drill to that level, but most often I'd be looking at the vendor level or just overall backorder amount and tracking that. Again this is why my initial thought was Power Query.