Forum Discussion
Helper IMark smallest date value in group
I want to create a column similar to the far right one in this table:
| Location | Iteration | Date | Starter |
| A | 1 | 1/1/2020 | Y |
| A | 1 | 1/6/2020 | N |
| A | 1 | 1/14/2020 | N |
| A | 2 | 1/14/2020 | Y |
| A | 2 | 1/17/2020 | N |
| A | 2 | 1/23/2020 | N |
| B | 1 | 1/1/2020 | Y |
| B | 1 | 1/6/2020 | N |
| B | 1 | 1/14/2020 | N |
| B | 2 | 1/14/2020 | Y |
| B | 2 | 1/17/2020 | N |
| B | 2 | 1/23/2020 | N |
Basically I want to mark the first instance of the new iteration as a Starter "Y". So it would be the smallest date value for the iteration. But there can be multiple iterations marked as 1, but both location A and B should be marked as "Y" for the first #1. Does that make sense?
Thanks in advance!
7 Replies
- Greg_Deckler
Community Champion
MattRoed - See if this helps: https://community.powerbi.com/t5/Quick-Measures-Gallery/Lookup-Min-Max/m-p/985814#M434
Or perhaps this, See my article on Mean Time Between Failure (MTBF) which uses EARLIER: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/339586
- v-diye-msft
Community Support
Hi MattRoed
If you've fixed the issue on your own please kindly share your solution. if the above posts help, please kindly mark it as a solution to help others find it more quickly. If not, please kindly elaborate more. thanks!
