Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
RitaMunha
Helper I
Helper I

Crear calendario solo con días laborables

Hola a todos,

Estoy tratando de crear un calendario de día laborable con DAX. ¿Alguien tiene alguna sugerencia?

¿Puedo excluir días de la función de calendario? o puedo unirme a más de un intreval de fechas?

Gracias de antemano

1 ACCEPTED SOLUTION
DataZoe
Employee
Employee

Sí, puedes hacer eso, prueba esto:

Working Days Calendar = 
var cal = ADDCOLUMNS(CALENDAR(date(2020,4,1), date(2020,5,1)),"Working Date",if(WEEKDAY([Date]) in {1,7},blank(),[Date]))
var workingcal =  SUMMARIZE(filter(cal,isblank([Working Date])=false()),[Working Date])

var cal2 = ADDCOLUMNS(CALENDAR(date(2020,1,1), date(2020,2,1)),"Working Date",if(WEEKDAY([Date]) in {1,7},blank(),[Date]))
var workingcal2 = SUMMARIZE(filter(cal2,isblank([Working Date])=false()),[Working Date])

return union(workingcal,workingcal2)

También puede filtrar fechas específicas con una instrucción switch:

Working Days Calendar = 
var cal = ADDCOLUMNS(CALENDAR(date(2020,4,1), date(2020,5,1)),"Working Date",if(WEEKDAY([Date]) in {1,7},blank(),switch([date],date(2020,4,1),blank(),[Date])))
var workingcal =  SUMMARIZE(filter(cal,isblank([Working Date])=false()),[Working Date])

var cal2 = ADDCOLUMNS(CALENDAR(date(2020,1,1), date(2020,2,1)),"Working Date",if(WEEKDAY([Date]) in {1,7},blank(),[Date]))
var workingcal2 = SUMMARIZE(filter(cal2,isblank([Working Date])=false()),[Working Date])

return union(workingcal,workingcal2)

Respectfully,
Zoe Douglas (DataZoe)



Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/

View solution in original post

3 REPLIES 3
amitchandak
Super User
Super User

Puede hacer referencia al calendario en este archivo. El fin de semana ha sido excluido de la jornada laboral

https://www.dropbox.com/s/y47ah38sr157l7t/Order_delivery_date_diff.pbix?dl=0

Otros se pueden actualizar desde la mesa de vacaciones

Nueva columna en el calendario para vacaciones de otra tabla

Nueva columna: maxx(filter(table2,table2[Col1]- table1[col1] && table2[Col2]- table1[col2] ),table2[required_col])

DataZoe
Employee
Employee

Sí, puedes hacer eso, prueba esto:

Working Days Calendar = 
var cal = ADDCOLUMNS(CALENDAR(date(2020,4,1), date(2020,5,1)),"Working Date",if(WEEKDAY([Date]) in {1,7},blank(),[Date]))
var workingcal =  SUMMARIZE(filter(cal,isblank([Working Date])=false()),[Working Date])

var cal2 = ADDCOLUMNS(CALENDAR(date(2020,1,1), date(2020,2,1)),"Working Date",if(WEEKDAY([Date]) in {1,7},blank(),[Date]))
var workingcal2 = SUMMARIZE(filter(cal2,isblank([Working Date])=false()),[Working Date])

return union(workingcal,workingcal2)

También puede filtrar fechas específicas con una instrucción switch:

Working Days Calendar = 
var cal = ADDCOLUMNS(CALENDAR(date(2020,4,1), date(2020,5,1)),"Working Date",if(WEEKDAY([Date]) in {1,7},blank(),switch([date],date(2020,4,1),blank(),[Date])))
var workingcal =  SUMMARIZE(filter(cal,isblank([Working Date])=false()),[Working Date])

var cal2 = ADDCOLUMNS(CALENDAR(date(2020,1,1), date(2020,2,1)),"Working Date",if(WEEKDAY([Date]) in {1,7},blank(),[Date]))
var workingcal2 = SUMMARIZE(filter(cal2,isblank([Working Date])=false()),[Working Date])

return union(workingcal,workingcal2)

Respectfully,
Zoe Douglas (DataZoe)



Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/

Gracias @DataZoe funcionó muy bien

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors