How to sum the net flows over a 1 year period in DAX

[andyly85]

Hi community, 

I have 2 columns, one is the date and the other is net flows.  How do I sum net flows over a 1 year period in DAX please?

Thanks in advance

Andy

[andyly85]

So bascially the sum over 1 year for column B, does this help?  Thanks!

[xifeng_L · Accepted solution]

You can try the DATESYTD function.

Measure = CALCULATE(SUM('Table'[net flow]),DATESYTD('Table'[Date]))

Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

Thank you~

[andyly85]

Hi, thanks!  How about over 1 year please?

[xifeng_L]

Can provide some sample data and the expected result?