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

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!

  • Sean's avatar
    Sean
    Community Champion
    9 years ago

    Anonymous

    If you want a Measure try this instead

     

    Measure =
IF (
    ISBLANK ( DMEGF_ContractsProvider[Dt. Extension] );
    ( MIN ( DMEGF_ContractsProvider[Dt. Final] ) - TODAY () )
        * 1;
    ( MIN ( DMEGF_ContractsProvider[Dt. Extension] ) - TODAY () )
        * 1
)

    Good Luck! :smileyhappy: