Creating Conditional Column based on Date column

[meIdo]

Hi guys!

I want to create a new column which is categorized on basis of start date. I have attached picture below. 

Also, I don't know whether its possible or not but, can we automatically increase batch number if new date appears in the column?

Please note I am doing it in direct query. 

Thankswant to add batch comparing date value

[amitchandak · Accepted solution]

@meIdo , Create a rank on Start Date

a new column=

Rankx(Table, [Start Date],,asc,dense)

[meIdo]

I think RankX function is not supported in DirectQuery. Anyway Thanks