Forum Discussion

Analitika's avatar
Analitika
Post Prodigy
4 years ago
Solved

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

  • 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