Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to do a double For/While?

I have a table with the following information: Index Iteration Points 1 38 19 2 39 16 3 40 13 4 41 15 5 42 16 6 43 16   I need a double while/for to create ...
  • v-cazheng-msft's avatar
    v-cazheng-msft
    4 years ago

    Hi Anonymous,

     

    If you would like to achieve the desired result with a DAX formula, you may try this Measure.

    Avg =
VAR avg_ =
    CALCULATE (
        AVERAGE ( 'Table'[Points] ),
        FILTER (
            ALL ( 'Table' ),
            'Table'[Iteration] >= MAX ( 'Table'[Iteration] )
                && 'Table'[Iteration]
                    < ( MAX ( 'Table'[Iteration] ) + 3 )
        )
    )
VAR maxIndex =
    CALCULATE ( MAX ( 'Table'[Index] ), ALL ( 'Table' ) )
RETURN
    IF ( MAX ( 'Table'[Index] ) > maxIndex - 2, BLANK (), avg_ )

     

    Then, the result looks like this.

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please let me know. Thanks a lot!

     

    Best Regards,

    Community Support Team _ Caiyun

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous ,

A new column

Var _sum = sumx(filter(Table, [Index]>= earlier([Index]) && [Index]<= earlier([Index]) +2) , [Points] )

Var _cnt = countx(filter(Table, [Index]>= earlier([Index]) && [Index]<= earlier([Index]) +2) , [Points] )

return

divide(_sum,_cnt)

 

If needed you can check for _cnt > 2