topic Total Running with WEEKS by DATETABLE in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Total-Running-with-WEEKS-by-DATETABLE/m-p/3267158#M120962 <P>Hello,</P><P>&nbsp;</P><P>i have greate a Date Table and a simple table with values and Dates.<BR />Now i have add a running Total in this table.</P><P>&nbsp;</P><P>In the datetable i have add a Coloumn with YEAR and WEEK like</P><P>2023-02</P><P>2023-03</P><P>&nbsp;</P><P>All works fine but one YEAR switch i get peak which is not in the dataset the axe is sort by YEAR-Week if i switch it to running total it looks gut but then in the graph i miss the year-week 2024-01</P><P>&nbsp;</P><P>Where is the Mistake in my mind.<BR />File:&nbsp;<A href="https://easyupload.io/cuk5pc" target="_self">Download PBIX</A>&nbsp;</P><P>&nbsp;</P><P>Thanks</P><P><img /></P><P>&nbsp;</P><P>Thanks</P> Sun, 04 Jun 2023 14:02:09 GMT tausday 2023-06-04T14:02:09Z Total Running with WEEKS by DATETABLE https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Total-Running-with-WEEKS-by-DATETABLE/m-p/3267158#M120962 <P>Hello,</P><P>&nbsp;</P><P>i have greate a Date Table and a simple table with values and Dates.<BR />Now i have add a running Total in this table.</P><P>&nbsp;</P><P>In the datetable i have add a Coloumn with YEAR and WEEK like</P><P>2023-02</P><P>2023-03</P><P>&nbsp;</P><P>All works fine but one YEAR switch i get peak which is not in the dataset the axe is sort by YEAR-Week if i switch it to running total it looks gut but then in the graph i miss the year-week 2024-01</P><P>&nbsp;</P><P>Where is the Mistake in my mind.<BR />File:&nbsp;<A href="https://easyupload.io/cuk5pc" target="_self">Download PBIX</A>&nbsp;</P><P>&nbsp;</P><P>Thanks</P><P><img /></P><P>&nbsp;</P><P>Thanks</P> Sun, 04 Jun 2023 14:02:09 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Total-Running-with-WEEKS-by-DATETABLE/m-p/3267158#M120962 tausday 2023-06-04T14:02:09Z Re: Total Running with WEEKS by DATETABLE https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Total-Running-with-WEEKS-by-DATETABLE/m-p/3267483#M120990 <P><img /></P> <P>&nbsp;</P> Mon, 05 Jun 2023 01:14:13 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Total-Running-with-WEEKS-by-DATETABLE/m-p/3267483#M120990 wdx223_Daniel 2023-06-05T01:14:13Z