Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Get one week prior text

Hi Experts!   I have a table with Date, Code and a calculated column as "Method". Now I need to add another column/measure with previous week's Method. That is a table like this (this is a very sma...
Need Help
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    hi Ch 

    try to add a column like:'

    column = 
MAXX(
    FILTER(
        TableName,
        TableName[Date]=EARLIER(TableName[Date])-7
    ),
    TableName[Method]
)

     

    it worked like:

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

I edited the table a little bit. As an example, In the first row of the table, date is 27.09.2016. So one week back is 7 days back. And then the date should be 20.09.2016. Then "Prev week Method" should be the "Method" of 20.09.2016. Which is 35-40 Days. Hope this helps. Thank you for your time.

 

FreemanZ's avatar
FreemanZ
Super User
3 years ago

hi Ch 

try to add a column like:'

column = 
MAXX(
    FILTER(
        TableName,
        TableName[Date]=EARLIER(TableName[Date])-7
    ),
    TableName[Method]
)

 

it worked like: