Forum Discussion

Jmenas's avatar
Jmenas
Icon for Advocate III rankAdvocate III
9 years ago
Solved

Transform table with distinct values and no Dates

Hi all,   I have a problem with extracting some of my values for a table then having them with out a date but keep the ids from the other columns. What i mean is that i have a table like this:    ...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi Jmenas,

     

    According to your description above, you should be able to use the formula below to create calculate table in this scenario.:smileyhappy:

    Table = 
SUMMARIZECOLUMNS (
    Table1[Product Id],
    "Deliver A", SUM ( Table1[Deliver Client A] ),
    "Deliver B", SUM ( Table1[Deliver Client B] ),
    "Drivers", CONCATENATEX ( Table1, Table1[Driver], "," ),
    "URL", FIRSTNONBLANK ( Table1[URL], 1 )
)

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi Jmenas,

 

According to your description above, you should be able to use the formula below to create calculate table in this scenario.:smileyhappy:

Table = 
SUMMARIZECOLUMNS (
    Table1[Product Id],
    "Deliver A", SUM ( Table1[Deliver Client A] ),
    "Deliver B", SUM ( Table1[Deliver Client B] ),
    "Drivers", CONCATENATEX ( Table1, Table1[Driver], "," ),
    "URL", FIRSTNONBLANK ( Table1[URL], 1 )
)

 

Regards

  • Jmenas's avatar
    Jmenas
    Icon for Advocate III rankAdvocate III
    9 years ago

    v-ljerr-msft Thanks that help a lot. I had some other issues regarding the dates but I could solved it. 
     Thanks!

     

    cheers,
    Jorge