earliest
2 TopicsReturn Earliest Text Value to all rows of a group
Hi Community, I need help with DAX through PowerPivot (not PowerBI). I am trying to get the earliest ID of a subset(group) assigned to all rows of that group. The output I am trying to achieve is bellow *Last column - Earliest Unique ID. Any idea how to achieve this without usage of VAR (It does not work for my Excel version) Case ID Rank within Group Unique ID ??? Earliest Unique ID 1 1 1 1 1 2 2 1 1 3 3 1 2 1 4 4 2 2 5 4 3 1 6 6 4 1 7 7Solved1.4KViews0likes4Comments