Fill with same value based on index column or minimize table to one column

Anonymous — Thu, 03 Nov 2022 16:45:18 GMT

Hi everyone,

I am trying to solve the following problem where I have a table similar to the following one (in Power Query Editor):

I would like to get two of the following result but I don't know how to get it:

Thanks in advance.

Re: Fill with same value based on index column or minimize table to one column

v-luwang-msft — Fri, 04 Nov 2022 08:37:12 GMT

Hi Anonymous ，

Create new table:

Table 2 = SELECTCOLUMNS ( 'Table', "UID", 'Table'[UID], "Date1", CALCULATE ( MAX ( 'Table'[DATA1] ), FILTER ( 'Table', 'Table'[UID] = EARLIER ( 'Table'[UID] ) ) ), "Date2", CALCULATE ( MAX ( 'Table'[DATA2] ), FILTER ( 'Table', 'Table'[UID] = EARLIER ( 'Table'[UID] ) ) ), "Date3", CALCULATE ( MAX ( 'Table'[DATA3] ), FILTER ( 'Table', 'Table'[UID] = EARLIER ( 'Table'[UID] ) ) ) )

Table 3 = DISTINCT('Table 2')

Best Regards

Lucien

topic Fill with same value based on index column or minimize table to one column in Report Server

Fill with same value based on index column or minimize table to one column

Re: Fill with same value based on index column or minimize table to one column