Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

get previous Round value

hello... I have a fact   id val round 1 10 1 2 2 1 3 1 1 4 20 11 5 15 30 6 15 30     and I have a round Dim wich related to column round in the fact ID...
Need Help
  • sturlaws's avatar
    sturlaws
    7 years ago

    Assuming that the [order]-column can be used to identify the order of the rounds and that you have a relationship between table[round] and dimRound[ID], you can create this measure:

    Value previous round =
CALCULATE (
    sum(Table[val]));
    FILTER ( ALL ( dimRound ); dimRound[order] = SELECTEDVALUE ( dimRound[order] ) - 1 )
)
  • Anonymous's avatar
    Anonymous
    7 years ago

    thank you>>

     

    Measure22:=CALCULATE (
    SUM ( Table1[VAL] ),
    FILTER (
    ALL ( Table2),
    Table2[order] = IF (HASONEVALUE(Table2[order] ), VALUES ( Table2[order]) - 1 )
    )
    )

sturlaws's avatar
sturlaws
Icon for Resident Rockstar rankResident Rockstar
7 years ago

Assuming that the [order]-column can be used to identify the order of the rounds and that you have a relationship between table[round] and dimRound[ID], you can create this measure:

Value previous round =
CALCULATE (
    sum(Table[val]));
    FILTER ( ALL ( dimRound ); dimRound[order] = SELECTEDVALUE ( dimRound[order] ) - 1 )
)
Anonymous's avatar
Anonymous
Not applicable
7 years ago

thank you>>

 

Measure22:=CALCULATE (
SUM ( Table1[VAL] ),
FILTER (
ALL ( Table2),
Table2[order] = IF (HASONEVALUE(Table2[order] ), VALUES ( Table2[order]) - 1 )
)
)