Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
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
@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
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |