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 
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