Forum Discussion
Expression with the Today () function
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
Hi, Look this thread, i think would be part of the solution
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!
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 ())
AnonymousThis is a Calculated Column not a Measure!
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: