Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Union - Wrong columns

Hello, I'm trying to do a Union between two tables and the data doesn't go in the right columns. I know that I need to use selectcolumns in order to keep the data lineage, but my formula is more comp...
Need Help
Tips and Tricks
  • Mikelytics's avatar
    Mikelytics
    3 years ago

    Hi Anonymous 

     

    I think the problem is that you frist summarize and then add the column and this is was determeines the order of the second table. DId you thought about changing the order of the first table?

     

    TABLE3 =
    UNION (
                 
                  SELECTCOLUMNS(
                     'Table',
                     "Date",[Date],
                     "Produit",[Produit],
                     "Commande",[Commande],
                    "Ventes",[Ventes]
                  )
                  ,
                  FILTER (
                        ADDCOLUMNS (
                                SUMMARIZE ( CROSSJOIN ( 'Date', 'Table' ), 'Date'[Date], 'Table'[Produit] ),
                                "Commande", "zz",
                                "Ventes", IF ( ISBLANK ( [Ventes_] ), 0, ( [Ventes_] ) )
                              ),
                              [Ventes] = 0
                   )
    )

     

    Best regards
    Michael
    -----------------------------------------------------
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    Appreciate your thumbs up!
    @ me in replies or I'll lose your thread.

Mikelytics's avatar
Mikelytics
Icon for Resident Rockstar rankResident Rockstar
3 years ago

Hi Anonymous 

 

I think the problem is that you frist summarize and then add the column and this is was determeines the order of the second table. DId you thought about changing the order of the first table?

 

TABLE3 =
UNION (
             
              SELECTCOLUMNS(
                 'Table',
                 "Date",[Date],
                 "Produit",[Produit],
                 "Commande",[Commande],
                "Ventes",[Ventes]
              )
              ,
              FILTER (
                    ADDCOLUMNS (
                            SUMMARIZE ( CROSSJOIN ( 'Date', 'Table' ), 'Date'[Date], 'Table'[Produit] ),
                            "Commande", "zz",
                            "Ventes", IF ( ISBLANK ( [Ventes_] ), 0, ( [Ventes_] ) )
                          ),
                          [Ventes] = 0
               )
)

 

Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your thumbs up!
@ me in replies or I'll lose your thread.