Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Help with challenging SUMX calculated columns problem

Hello,   I am trying to do this: for every row in Table1, filter Table1 between the rows StartDate column and StartDate plus 90 days and then within that filtered date range for Table1, sum up all ...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    7 years ago

    Anonymous 

     

    You may refer to the DAX below.

    Column =
VAR d = Table1[StartDate]
RETURN
    SUMX (
        FILTER ( Table1, Table1[StartDate] >= d && Table1[StartDate] <= d + 90 ),
        Table1[Revenue]
    )
v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
7 years ago

Anonymous 

 

You may refer to the DAX below.

Column =
VAR d = Table1[StartDate]
RETURN
    SUMX (
        FILTER ( Table1, Table1[StartDate] >= d && Table1[StartDate] <= d + 90 ),
        Table1[Revenue]
    )