Got Zeros when publish week over week

[Arpansingh28]

Hi ,

i have a dashboard in which i have data for last 6 months , we update weekly data for current month and previous month (last date update, for dec2022, 12/31/2022 updated ) and when we do so, we update last weeks data with current one.

i.e. last week's file date no longer exists resulting in zeroes for the user until they reselect the date which points them to this week's date

Currently the viewer must reselect the date in the current month dropdown when we publish week over week

how can i get rid of it so when i will publish it will show data for recent updated week by default and user should also have options to check data for other months too

[Arpansingh28]

Thanks @amitchandak for your response, but i am still getting same error and zeros

as you can see from screenshot that when i update data after that i hit refresh than i hit zeros in my dashboard......now issue is that now i have to select down feb-2023 to show numbers and then other feb-2023 option will disappear and it works fine then...... how can i solve that issue 

[amitchandak · Accepted solution]

@Arpansingh28 , Assume You have week number or week start date , based on that you can create a new column and use that 

Switch( True(),

[Weel Start Date] = max(Table[Date])  - weekday(max(Table[Date]) ,2) +1 ,  "Latest Week" , //Monday week

[Year Week] & ""

)

Default Date Today/ This Month / This Year: https://www.youtube.com/watch?v=hfn05preQYA