Forum Discussion

edgibson's avatar
edgibson
Regular Visitor
7 years ago
Solved

Calculating 30/60/90 Day Interval Help

Hello!    I've searched everywhere and tried all similar questions, but cannot get it to match my data at all. Can someone please help.   I have two data sources. They both have a relationship of...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    edgibson 
    Yes.
    SUM shold have 1 argument. Also try putting the last argument in brackets.

    30 =
'070719ahareport'[ Assigned Amount ]
    - CALCULATE (
        SUM ( 'Sheet1 (2)'[amount] ),
        FILTER (
            'Sheet1 (2)',
            'Sheet1 (2)'[Date] <= ( '0707ahareport'[ assign date] + 30 )
        )
    )

    Thanks!
    A

Anonymous's avatar
Anonymous
Not applicable
7 years ago

edgibson 

I believe you need to put the dates in the filter, not the amount. The amount is in the SUM function.

Cheers!
A

edgibson's avatar
edgibson
Regular Visitor
7 years ago

Anonymousthanks for your help. I think i'm ready to give up. 

 

30 = '070719ahareport'[ Assigned Amount ] - CALCULATE(SUM('Sheet1 (2)'[amount], FILTER('Sheet1 (2)','Sheet1 (2)'[Date] <= '0707ahareport'[ assign date] + 30)))

tells me too many arguments were passed to the SUM function. The maximum count for the function is 1. 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    edgibson 
    Yes.
    SUM shold have 1 argument. Also try putting the last argument in brackets.

    30 =
'070719ahareport'[ Assigned Amount ]
    - CALCULATE (
        SUM ( 'Sheet1 (2)'[amount] ),
        FILTER (
            'Sheet1 (2)',
            'Sheet1 (2)'[Date] <= ( '0707ahareport'[ assign date] + 30 )
        )
    )

    Thanks!
    A

    • edgibson's avatar
      edgibson
      Regular Visitor
      7 years ago

      Thank you Anonymous ! I just need to maneuver the calculation a bit - but that gives me the basis of what I needed. Thank you for the persistence and help! 

       

      Cheers! 

      Ed

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Good Luck.
        Next time try to provide sample data, it will be easier to assist.

        Follow the same logic for the 60 and 90 columns. 

         

        Thnaks!
        A