https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-sum-the-net-flows-over-a-1-year-period-in-DAX/m-p/3958265#M153609 <P>Can provide some sample data and the expected result?</P> Wed, 29 May 2024 14:12:16 GMT xifeng_L 2024-05-29T14:12:16Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-sum-the-net-flows-over-a-1-year-period-in-DAX/m-p/3958192#M153605 <P>Hi community,&nbsp;</P><P>&nbsp;</P><P>I have 2 columns, one is the date and the other is net flows.&nbsp; How do I sum net flows over a 1 year period in DAX please?</P><P>&nbsp;</P><P>Thanks in advance</P><P>&nbsp;</P><P>Andy</P> Wed, 29 May 2024 13:28:35 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-sum-the-net-flows-over-a-1-year-period-in-DAX/m-p/3958192#M153605 andyly85 2024-05-29T13:28:35Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-sum-the-net-flows-over-a-1-year-period-in-DAX/m-p/3958265#M153609 <P>Can provide some sample data and the expected result?</P> Wed, 29 May 2024 14:12:16 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-sum-the-net-flows-over-a-1-year-period-in-DAX/m-p/3958265#M153609 xifeng_L 2024-05-29T14:12:16Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-sum-the-net-flows-over-a-1-year-period-in-DAX/m-p/3958302#M153611 <P><img /></P><P>So bascially the sum over 1 year for column B, does this help?&nbsp; Thanks!</P> Wed, 29 May 2024 14:25:46 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-sum-the-net-flows-over-a-1-year-period-in-DAX/m-p/3958302#M153611 andyly85 2024-05-29T14:25:46Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-sum-the-net-flows-over-a-1-year-period-in-DAX/m-p/3958348#M153613 <P>You can try the DATESYTD function.</P><P>&nbsp;</P><LI-CODE lang="markup">Measure = CALCULATE(SUM('Table'[net flow]),DATESYTD('Table'[Date]))</LI-CODE><P>&nbsp;</P><P>&nbsp;</P><P>Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !</P><P>&nbsp;</P><P>Thank you~</P> Wed, 29 May 2024 14:45:20 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-sum-the-net-flows-over-a-1-year-period-in-DAX/m-p/3958348#M153613 xifeng_L 2024-05-29T14:45:20Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-sum-the-net-flows-over-a-1-year-period-in-DAX/m-p/3958360#M153614 <P>Hi, thanks!&nbsp; How about over 1 year please?</P> Wed, 29 May 2024 14:48:18 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-sum-the-net-flows-over-a-1-year-period-in-DAX/m-p/3958360#M153614 andyly85 2024-05-29T14:48:18Z