Forum Discussion
WTD Measure
Hi, I am trying to display week to date sales on the card visualization. I do have a date table and have columns verifying the number of the day of the week (Sunday =0, Monday = 1, etc). I even creat...
Thank you Jay! I actually got my DAX code to work. Thank you for your help.
Anonymous Hi Jay, I've ran across a hiccup with the Dax Code I was using, due to budget forcast updates that it pushes the dates out and I was using LASTDATE, so I was getting a zero for my WTD Sales.
So, I was trying what you suggested, however my YearWeek is showing the same value instead of it changing when it gets to the new week start to week end. Any suggestions? The value in the Actual column for example Start of Week May 3, 2020 to End of Week May 9, 2020 is what I'm trying to display on my visulation card and would like it to update everyday when the data refreshes. Thanks for your help!