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] ...
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
LD's avatar
LD
Frequent Visitor
4 years ago

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

 

LD