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