Forum Discussion
Analitika
4 years agoPost Prodigy
Excluding weekends in visual when using date in Power BI
Hello,
I would like to ask how to make that in visual weekend days will be excluded in Power BI?
Analitika , Create a flag in the date table
Weekend = if(weekday([date],2) >=6,1,0)
Use this in measure or visual level filter and filter Weekend = 0
1 Reply
- amitchandakSuper User
Analitika , Create a flag in the date table
Weekend = if(weekday([date],2) >=6,1,0)
Use this in measure or visual level filter and filter Weekend = 0