Sum Value per Months

[LD]

Dear All,

I have two database with:

First is

Date [Start Date] --- [AAA] (that is a Value) 

Second is

Date [Month] ---- [YTD_IN/OUT]

I would like to have in [YTD_IN/OUT] the sum of [AAA] clusterized per Month ([Month]=[Start Date]), so I have:

"YTD_IN/OUT",CALCULATE(SUM('IN/OUT'[AAA]),

FILTER (

ALL('IN/OUT'[Start Date]),

'IN/OUT'[Start Date] <= MAX(projection[Month])

But the formula sum the previuos Months too.

Please, How i can Solve?

Thank you

LD

[LD · Accepted solution]

Dear All,

I solved the point: 

the solution is:

CALCULATE(SUM('IN/OUT'[AAA]),

FILTER (

ALL('IN/OUT'[Start Date]),

'IN/OUT'[Start Date] <= LASTDATE(projection[Month])

LD

[LD]

Hi, 
Thanks for your message. I think I have soleved the point 🙂

LD

[v-zhangti]

Hi, @LD 

Can you provide some sample data or simple pbix files? Sensitive information can be removed in advance. What kind of expected results do you expect? You can also show it with pictures. 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.