Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Finding first date in table where column changes value

I have a table with a date column and a number column. Example:   Date Number 01-01-'21 4 02-01-'21 4 03-01-'21 2   I want to add a calculated column that returns the first da...
Need Help
  • Fowmy's avatar
    Fowmy
    5 years ago

    Anonymous 

    Add the following Calc Column:

    Number Change = 
var __num = [Number]
var __date = [Date]
return
CALCULATE(
    MIN(Table3[Date]),
    Table3[Number] <> __num,
    Table3[Date] > __date,
    REMOVEFILTERS(Table3)
)

     

Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
5 years ago

Anonymous 

Add the following Calc Column:

Number Change = 
var __num = [Number]
var __date = [Date]
return
CALCULATE(
    MIN(Table3[Date]),
    Table3[Number] <> __num,
    Table3[Date] > __date,
    REMOVEFILTERS(Table3)
)