Forum Discussion

Napes001's avatar
Napes001
Regular Visitor
2 years ago
Solved

Column A Sum based on Column B Dates

Im trying to get the measure sum of a column from a table by the dates of the second column and display as sum which is then filtered by the date calander. 

Example: 

Ordered AmountDelivery Date
$100 
$15001-01-2023
$7515-02-2023
$20 
$25 
$10020-01-2023

 

The return should be $325, Which then should be able to be filtered down further by a slicer date table.

 

thanks 

 

Date
measure
sum

5 Replies

  • Napes001's avatar
    Napes001
    Regular Visitor
    2 years ago

    I figured out the issue, I had an inactive date relationship. Added in the USERELATIONSHIP and it now works correctly. thank you for your help. 

  • FreemanZ's avatar
    FreemanZ
    Icon for Super User rankSuper User
    2 years ago

    hi Napes001 ,

     

    could you say more about your expectation, ideally with expected result table?

  • Napes001's avatar
    Napes001
    Regular Visitor
    2 years ago

    The table columns are similar to the above table with blank dates. The expected result would be: SUM of "Ordered Amount" with dates. 


    So based on the table on the original post, My expectation is that the result would be $325 - only sum of Ordered Amoiunt that has delivery dates.

     

    This would then be able to be filtered with the Date calander. IE: Filter by Jan 2023 = $250, Feb = $75 = March = $0.00, etc

     

    I hope this makes sense?

     

      • Napes001's avatar
        Napes001
        Regular Visitor
        2 years ago

        Thanks FreemanZ, This appears to be working to an extent. But when I try and filter with my Calander table it wont show anything past 'todays' data?

        If I dont filter, it shows the total correctly of past, present and future. I have added a image to hopefully clarify. I appreacitate your help, This is all a new learning

         

        .