How can I roll weekend sales into the previous Friday?

[ukhan2020TO]

Hello,

I am making a daily sales trend chart in PowerBi. However, in our Business, weekend sales are minimum. Thus, the daily sales trends tends to make large dips on the weekend. How can i roll the weekend sales into the previous Friday in order to ensure that i get a smooth trendline. 

[amitchandak · Accepted solution]

@ukhan2020TO , please create this column in your calendar.  Join should remain on date column. This display column

Work Day = if(WEEKDAY([Date],2)>=6,0,1) // Find week end
Work Date With WE = if([Work Day]=0,maxx(FILTER('Date',[Date]<EARLIER([Date]) && [Work Day]<> EARLIER([Work Day]) ),[Date]),[Date]) // Sat, Sun give date of friday

Add these and use Work Date With WE  on axis. You can change name as per need

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/

See if my webinar on Time Intelligence can help: https://community.powerbi.com/t5/Webinars-and-Video-Gallery/PowerBI-Time-Intelligence-Calendar-WTD-Y...


Appreciate your Kudos.

[ukhan2020TO]

Thanks so much! Worked like a charm!