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

Hey edgibson 

That is fine.

Create something like

30 = 
CALCULATE(...
FILTER(Table, [Date] <= 'Table'[Assigned Date] + 30)
...
)

That should give you the date range from [Assigned Date] to [Assigned Date] + 30

 

Cheers!
A

edgibson's avatar
edgibson
Regular Visitor
7 years ago

Anonymous I think I'm getting somewhat close.... thank you for the continued assistance...

 

30 = '070719ahareport'[ Assigned Amount ] - CALCULATE(SUM('Sheet1 (2)'[amount], FILTER('Sheet1 (2)'[amount] + 30)))
  • 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