Forum Discussion

nazdravanul's avatar
nazdravanul
Frequent Visitor
8 years ago

Merge problems - incorrect expand

Hi all,    I have the following problem. I have 2 tables, which have the following approximate format:   Table 1 (selection of columns)   Email           Transaction ID  Date              Payme...
Need Help
userpbi55's avatar
userpbi55
Frequent Visitor
7 years ago

I have this problem as well using Power BI Desktop May 2019 Report Server. Group By before merge => random expand results for whole number/integer data type.

luisamboni's avatar
luisamboni
Frequent Visitor
7 years ago

any solution?

  • userpbi55's avatar
    userpbi55
    Frequent Visitor
    7 years ago

    Hi, try adding an Index column after the "Group by". This seems to work for me.

    • luisamboni's avatar
      luisamboni
      Frequent Visitor
      7 years ago

      I got a satisfactory result after including a Table.Buffer() before the SORT().