Forum Discussion
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 Amount Deliver...
FreemanZ
Super User
Super Userhi 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
.