Forum Discussion
Help
Check this out, you have the name of the vendor in your Mat Description, you create a duplicate of your material and split it into the first part until vendor and last part with vendor, then you split the vendor column into one part of the vendor itself, then you compare them, if it is the same, then you take the base Mat description, without vendor name, if they are not the same then you take material as it was.
Might be a bit confusing, but check the power query and if you still have questions, let me know.
Hi Olgad, This is amazing and i think it will solve the problem. I have had a look at the Pbix file and it looks great. Kinda confused on the power query part, could you help me with the power query you made use of in this example? Otherwise i can try to figure it out and let you know if it works for me. Thanks a bunch!
Thanks Olgad, I have applied the power query and achieved a common Material description for both materials as highlighted below. However the Total receipts are still summed up individually
the only thing that comes to my mind, go back to power query , select Material description and trim it, may be a space is left somewhere and pbi still treats it as two separate materials.
because we have identical measure and for me it works
Thank you Olgad, been very helpful! I trimed and for some reason i seem to get the right total receipt now. However it seem to be static and not affected when you play around with the date as seen in the second screenshot