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)
Anonymous's avatar
Anonymous
Not applicable
7 years ago

I getting the following error: 

 

A single value for column 'WELL' in table 'BODS' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.

 

Here is my code

 

Column =
VAR Cat = BODS[WELL]
RETURN
RANKX(FILTER(BODS,BODS[WELL]=Cat),FIRSTDATE(BODS[REPORT_DATE]),,ASC)

 

I'm terrible at DAX :(