Rank column at each occurrence

[jgralow]

I have a date column that I am trying to rank at every change in date, the date repeats for hundreds of rows until new data is added with a new capture date.  I am trying to add a value for each date so i can show variances in other units of measure basic on when the data was captured.

[v-chuncz-msft · Accepted solution]

@jgralow,

You may refer to the following thread.

http://community.powerbi.com/t5/Desktop/How-to-create-ID-variable-by-value-an-other-variable/m-p/369...