Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Expression with the Today () function

I need to create a measure or column that should use the Today () function.   I have a table with two columns of dates, one that is due date that is of type null and the other that is extension dat...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Sean

    I created the measure but the following error is occurring:

     

    "A single value for column 'Dt. Extension' in table 'DMEGF_ContractsSupplier' can not be determined." This can happen when a measure refers to a column that contains many values without specifying an aggregation such as min, max, count, or to Get a single result. "

     

    If (ISBLANK (DMEGF_ContractsSupplier);

    DMEGF_ContractsProvider [Dt. Final] - TODAY ();

    DMEGF_ContractsProvider [Dt. Extension] - TODAY ())

  • Sean's avatar
    Sean
    Community Champion
    9 years ago

    Anonymoussince you're always dealing with TODAY - you just need to check IF there has been an extenstion to determine which date to use in the subtraction (at least that's how I understand your question)

    If that is the case you can try this

     

    Column (Days) =
IF (
    ISBLANK ( 'Table'[Dt. Prorrogação] );
    'Table'[Dt. Final] - TODAY ();
    'Table'[Dt. Prorrogação] - TODAY ()
)

     

    EDIT: You may have to change the Data Type of the Column in the Modeling Tab to Whole Number otherwise will show you dates!

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Sean

      I created the measure but the following error is occurring:

       

      "A single value for column 'Dt. Extension' in table 'DMEGF_ContractsSupplier' can not be determined." This can happen when a measure refers to a column that contains many values without specifying an aggregation such as min, max, count, or to Get a single result. "

       

      If (ISBLANK (DMEGF_ContractsSupplier);

      DMEGF_ContractsProvider [Dt. Final] - TODAY ();

      DMEGF_ContractsProvider [Dt. Extension] - TODAY ())

      • Sean's avatar
        Sean
        Community Champion
        9 years ago

        AnonymousThis is a Calculated Column not a Measure!