max date group by columns

[KV2022]

Hi, please help

id	stage	start	end	iteration
1	1	27-Jul	28-Jul	1
1	2	30-Jul	1-Aug	1
1	1	2-Aug	4-Aug	2

For this, i need to calculate max of start date for each stage

[amitchandak]

@KV2022 , A new column

Maxx(filter(Table, id = earlier([ID])  && [Stage] = earlier([Stage]) ), [Start Date])

If needed refer

https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0

[KV2022]

Sorry. I gave a wrong scenario. 

Output should be like

id stage1 value stage2 value stage3 value

Stage names should be dynamic. here the value are same calculations(diff b/w two dates in days)  for each stage. I  need to write the stage name for each stage in a crosstab. Please help.