Forum Discussion

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 Amount Deliver...

FreemanZ
2 years ago
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:
Napes001 - SUM dates with record.pbix38 KB

Icon for Super User rank

Super User

2 years ago

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

Related content