Forum Discussion

drgenius's avatar
drgenius
Frequent Visitor
4 years ago
Solved

Calculate a value with the difference from a timestamp column and current timestamp in DAX

 Hi,

 

New to power bi and I want some help with DAX. I have a column with values and I want if the timesamp of the row is bigger than 30 days (current timestamp)  then the value has to be null. 

For example in sql : case when datediff(current_timstamp(), timestamp_column) >= 30 then null else column end as column_new

 

Can you please help me ?

Thank you in advance.

 

Tutorial Requests
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi,
    Can you try to adjust this formula and see if it works for you:

    Datediff = if(DATEDIFF('Date Table'[Date],TODAY(),DAY)>=30,0,1)

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi,
    Can you try to adjust this formula and see if it works for you:

    Datediff = if(DATEDIFF('Date Table'[Date],TODAY(),DAY)>=30,0,1)