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)
)

     

CNENFRNL's avatar
CNENFRNL
Icon for Community Champion rankCommunity Champion
5 years ago
Changing Date = 
MINX (
    FILTER (
        INFO,
        INFO[Date] > EARLIER ( INFO[Date] )
            && INFO[Value] <> EARLIER ( INFO[Value] )
    ),
    INFO[Date]
)