Forum Discussion

godtooro's avatar
godtooro
Helper II
2 years ago
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] < BIFAR0...
General Comment
Need Help
Tips and Tricks
  • godtooro's avatar
    godtooro
    2 years ago

    Thank u Anonymous !
    Working!!!!!!

    Thank you so much!

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hello godtooro Try this measure.
Overdue Amount = SUMX( FILTER(BIFAR000, BIFAR000[Due Date] < BIFAR000[Date of Dataset]), BIFAR000[Amount] )

  • godtooro's avatar
    godtooro
    Helper II
    2 years ago

    Thank u Anonymous !
    Working!!!!!!

    Thank you so much!

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hello godtooro Please accept as a solution!.