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
2 Replies
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.
