Today()-7 datra in calculated column

[Anonymous]

Hi All,

Can we convert this measure into Calculated column?

Measure 3 = CALCULATE(MAX(Table1[Values]),FILTER(ALL(Table1),[Date]=MAX(Table1[Date])-7))

https://community.powerbi.com/t5/Desktop/Today-1-data-for-each-record/m-p/837285#M402108

Thanks in Advance.

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

Column = 
VAR d = [Date] - 7
RETURN
    CALCULATE ( SUM ( 'Table'[value] ), FILTER ( 'Table', [Date] = d ) )

[Anonymous]

Yes, just create index columns starting with 0 and 1 then merge teh table with itself