Forum Discussion

gree1502's avatar
gree1502
Helper II
9 years ago
Solved

Create a measurement based on date

Hi,

 

I have table with column "notification date". This column is not unique.

 

I need to create a measurement, where the difference between now() and notification date should be greater than 45 days.

 

I tried using DateDiff : NotificationDateDiff = (DATEDIFF(tablename[Notification Date],NOW(),DAY)) > 45

It gives me following error:

A single value for column 'Notification Date' in table 'tablename' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.

 

Can anyone help me with this?

 

Appreciate the help.

Thanks

Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    9 years ago

    You could try a couple things. One, put a MAX or other aggregator around your Notification Date in your formula. Or, you could put this formula into a calculated column.

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    9 years ago

    You could try a couple things. One, put a MAX or other aggregator around your Notification Date in your formula. Or, you could put this formula into a calculated column.

    • gree1502's avatar
      gree1502
      Helper II
      9 years ago

      Thanks for the response.

      I don't understand the use of max here. I want to check each record, if the difference is > 45.

      consider that date if > 45 else ignore.

       

      Can you elaborate?