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

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