Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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.
Solved! Go to Solution.
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
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
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
3 | |
2 | |
2 | |
2 | |
2 |