topic Re: filter Table of holidays in DAX Commands and Tips

filter Table of holidays

Syndicate_Admin — Tue, 25 Jun 2024 13:50:01 GMT

Hello, I have a measurement to calculate the delivery days, taking into account working days and holidays:

"DiasCierre = NETWORKDAYS ( PLZENT [F.PED] , PLZENT [F.Cie.PED] , 1 , VALUES ( FestPto [FechaFest] )"

Orders are from different PTOVTA outlets.

And the festive table contains the PTOVTA and FechaFest columns.

How do I get PTOVTA Fest to filter dates?

It currently takes into account the public holidays of all PTOVTA

Re: filter Table of holidays

Syndicate_Admin — Tue, 25 Jun 2024 14:07:04 GMT

I tried this but it gives an error:

CALCULATE(NETWORKDAYS(PLZENT[F.PED],PLZENT[F.Cie.PED],1,values(Holidays[FechaFest])),Holidays[PtoGestion]=PLZENT[PtoGestion] )

Re: filter Table of holidays

Anonymous — Wed, 26 Jun 2024 02:08:23 GMT

Hi Joseluislg

You can try something like below. It is a column formula here.

Delivery Days = VAR pto = PLZENT[PtoGestion] RETURN NETWORKDAYS(PLZENT[Start date], PLZENT[End date], 1, CALCULATETABLE(VALUES(FestPto[FechaFest]),FestPto[PtoGestion]=pto))

Additionally, if there is a relationship between two tables on PtoGestion column and the cross-filter direction is Single (PLZENT filters FestPto), you can also try this for a column

Delivery Days 2 = NETWORKDAYS(PLZENT[Start date], PLZENT[End date], 1, SELECTCOLUMNS(RELATEDTABLE(FestPto),"holidays",'FestPto'[FechaFest]))

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!