Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Calculated column (DAX) with next consecutive value

Hi everyone,   I need help with what I think could be a fairly simple issue, but I'm still a newbie and really can't get it to work.   I would like to create a calculated column (with DAX) to fin...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    Hi,

    Please check the below picture and the attached pbix file.

    It is for creating a new column.

     

    Goal CC =
VAR currentoccurrence = Data[Occurrence]
VAR currentvalue = Data[Value]
VAR newtable =
    FILTER (
        Data,
        Data[Occurrence] = currentoccurrence
            && Data[Value] > currentvalue
    )
VAR goalvalue =
    MINX ( newtable, Data[Value] )
RETURN
    goalvalue
Jihwan_Kim's avatar
Jihwan_Kim
Super User
4 years ago

Hi,

Please check the below picture and the attached pbix file.

It is for creating a new column.

 

Goal CC =
VAR currentoccurrence = Data[Occurrence]
VAR currentvalue = Data[Value]
VAR newtable =
    FILTER (
        Data,
        Data[Occurrence] = currentoccurrence
            && Data[Value] > currentvalue
    )
VAR goalvalue =
    MINX ( newtable, Data[Value] )
RETURN
    goalvalue
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thanks!!