Forum Discussion
Column A Sum based on Column B Dates
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?
FreemanZSuper User
hi Napes001 ,
try to plot the month column with a measure like:
measure = CALCULATE( SUM(data[Ordered Amount]), data[Delivery Date]<>BLANK() )it worked like:
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
.