cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tausday
New Member

Total Running with WEEKS by DATETABLE

Hello,

 

i have greate a Date Table and a simple table with values and Dates.
Now i have add a running Total in this table.

 

In the datetable i have add a Coloumn with YEAR and WEEK like

2023-02

2023-03

 

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

 

Where is the Mistake in my mind.
File: Download PBIX 

 

Thanks

picture.png

 

Thanks

1 ACCEPTED SOLUTION
wdx223_Daniel
Super User
Super User

1 REPLY 1
wdx223_Daniel
Super User
Super User

wdx223_Daniel_0-1685927646807.png

 

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors
Top Kudoed Authors