Forum Discussion
Ignore Weekend in Forecast
I managed to figure it out by doing lots of reading/youtube/googling the fix was as follows.
1) Go to Transform Data.
2) In the Transcation Table, click on Add Column, then Custom Column
3) Give it a name, say Weekend for example.
4) In the Custom Column Formula section, input the following (without the quotes):
"if Date.DayOfWeek([INVOICE_DATE], Day.Monday) > 4
then
"Weekend"
else
"Weekday""5) Click Ok
6) Click Close&Apply
7) Add new Weekend field as a Filter on this page
😎Select Weekday
9) Problem solved :).
Hi! AhmedT001
I think you are on right track, if you can have an identifier for weekend then you can exclude that from your visual by using page level/ visual level filter to avoid weekends, hope this helps, if not please share the sample data to reproduce the same.
Yes this is the route I had to go down, I've posted my solution as well.