topic Re: value from a table 30 days ago in DAX Commands and Tips

value from a table 30 days ago

Jeffrey_VC — Tue, 31 Oct 2023 07:20:29 GMT

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

Re: value from a table 30 days ago

Dangar332 — Tue, 31 Oct 2023 08:52:21 GMT

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]) )

Re: value from a table 30 days ago

Jeffrey_VC — Tue, 31 Oct 2023 09:02:02 GMT

Hi Dangar332,

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

Re: value from a table 30 days ago

Dangar332 — Tue, 31 Oct 2023 09:05:02 GMT

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) )

Re: value from a table 30 days ago

Jeffrey_VC — Tue, 31 Oct 2023 09:15:37 GMT

Dangar332
Thnx!