value from a table 30 days ago

[Jeffrey_VC]

Hi everyone,

I'm trying to find a dax code to get a value of a table 30 days ago.

I have a tabel with 3 colums.
Code (there are different codes in the colum)

Timestamp

Loginfo

I need the "loginfo" with code 987 and timestamp 30 days ago.

Thnx

Jeffrey

[Dangar332]

Hi, @Jeffrey_VC 

@Jeffrey_VC 

you can try dateadd function

result =
calculate(
        min('yourtablename'[loginfo]),
       'yourtablename'[timestamp]= max('yourtablename'[timestamp])-30,
       'yourtablename'[code]=max('yourtablename'[code])
          )

[Jeffrey_VC]

Hi @Dangar332,

Thanks for your reply.
It almost works. I also need the condition code = 987

[Dangar332 · Accepted solution]

hi, @Jeffrey_VC 

if code column is type of string then use  "987"  instead of 987

result =
calculate(
        min('yourtablename'[loginfo]),
       'yourtablename'[timestamp]= max('yourtablename'[timestamp])-30,
       'yourtablename'[code]=987)
          )

[Jeffrey_VC]

@Dangar332 
Thnx!