Forum Discussion
Solved
Calculate if
Dear all!
Please I need you support.
I want to calculate if [Due Date] < [Date of DataSet].
I've tried:
Overdue Amount =
var _DuelesDate = FILTER(BIFAR000, BIFAR000[Due Date] < BIFAR000[Date of Dataset])
return
SWITCH(
TRUE,
_DuelesDate, [Amount])
But is not working.
I've tried:
CALCULATE(
[Amount],
BIFAR000[Due Date] < BIFAR000[Date of Dataset])
But neither.
Do you have an idea?
Thank u Anonymous !
Working!!!!!!Thank you so much!
5 Replies
Hello godtooro Try this measure.
Overdue Amount = SUMX( FILTER(BIFAR000, BIFAR000[Due Date] < BIFAR000[Date of Dataset]), BIFAR000[Amount] )Hi Anonymous you were right.
I've changed data type to date and solved.
