Forum Discussion
max date group by columns
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
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
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.
