Forum Discussion

sfn's avatar
sfn
Frequent Visitor
8 years ago
Solved

Normalizing Periods from Dates

Hi,   Does anyone have experience with normalizing date ranges to represent periods starting at n for a set of categories?   I have a lot of data on hours spent to execute specific projects, and ...
Need Help
  • Stachu's avatar
    Stachu
    8 years ago

    so you basically want to rank the dates for each category
    try this calculated column

    Column = 
VAR Cat = Table[Category]
RETURN
RANKX(FILTER(Table,Table[Category]=Cat),FIRSTDATE(Table[Date]),,ASC)
Stachu's avatar
Stachu
Community Champion
8 years ago

so you basically want to rank the dates for each category
try this calculated column

Column = 
VAR Cat = Table[Category]
RETURN
RANKX(FILTER(Table,Table[Category]=Cat),FIRSTDATE(Table[Date]),,ASC)
sfn's avatar
sfn
Frequent Visitor
8 years ago

Yes, this resulted in what I was looking for - thanks!