Catalin: I did it!! Hurra.. as we say it in my country, Norway.. -< Just wanted to say I am happy for your contribution here as well. I wi...
Hi Riny, Wow - it worked adding Table.Buffer around the sorting step, now saying Yes output of legal contracts! First I sorted some columns in s...
Hi Riny, To post 28; this is why I about two weeks ago tried to expand my test data set a bit. Else you are probably right about using another uniq...
Hi Riny, What I mostly try to illustrate in last post to you, is still some inconsisty in the earlier Excel file you made (merged) to me. See at...
Hi Catalin, To your last response, see attachment. I added two steps after your code, in order to have amount in table. There is still something...
Hi Riny, You are right about SupplNr 330, I just didn’t see the year different, as day and month were the same. Now I’ve taken your steps over i...
Hi again, Finally I understood not using the Merge Columns button (perhaps meaning Append for columns matching, witch is the opposite of merging ro...
Hi Riny, Could you try Merge button in Power BI Query yourself, see attachment. I'm not able to choose Merge button there, it's all greyed out. Rea...
Riny: Aha! I didn't know AND is prioritized before OR when using Distinct (wonder what happens if more than one Yes same SupplNr on different dates...
Hi Riny, Opened your last file. To last step Merged table: For SupplNr 227, is it random that No disappear, leaving Yes behind? (seems like a 50% c...
Hi Riny, Example dates can ba some old, in production at least those will be mostly 12 months old. Sorry for a bit random transactions dates if so....
Hi Riny and others, I also have another suggestion/or question to solution, using iterations (looping). See Yes-or-No-code-testing-OrganizationNr-m...
Hi Riny, Files attached (thought I did that last post butI probably forgot uploading first) Trond
Hi Riny, Okey, lets focus in two steps: 1) getting the existing file to work as intended, and 2) consider an extension regarding Product categories...
Riny: Btw, getting some error when copying the sentence in Merged table (Source step). The table that are produced in a column, has null in all its...