Forum Discussion

LD's avatar
LD
Frequent Visitor
4 years ago
Solved

Sum Value per Months

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
Interesting Links
Need Help
  • LD's avatar
    LD
    4 years ago

    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

3 Replies

  • v-zhangti's avatar
    v-zhangti
    Icon for Community Support rankCommunity Support
    4 years ago

    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.

  • LD's avatar
    LD
    Frequent Visitor
    4 years ago

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

     

    LD

  • LD's avatar
    LD
    Frequent Visitor
    4 years ago

    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