Fabric is Generally Available. Browse Fabric Presentations. Work
towards your Fabric certification with the Cloud Skills Challenge.
hi there ,
i have a table "A "as below , i would like to create another new table" B" which shows the latest prices based on latest date .Could you pls help me
Go to Solution.
Just in case you want to do it in Power Query, you can use the concept of grouping.
Sharing the file with the logic implemented for your reference.
View solution in original post
You could create Table B as
Table B = GENERATE( ALLNOBLANKROW( 'Table A'[Material]),
SELECTCOLUMNS( TOPN(1, 'Table A', 'Table A'[Date]), "Date", 'Table A'[Date], "Price", 'Table A'[Price])
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.