Public holiday and weekends

[Aspiring_Developer]

Hi All,

I have attached the sample Data set .

I am showing the value for a KPI named "On Hand Volume " using below expression :-
Sum({<isLastDayOfMonth={1}>}TREND_VOL)

It is working fine till Nov 2022

What i want to achieve here is that for Dec 2022 it should show the opening value for Jan 2023 .
Also , In jan 2023 , it should show the valu for 3 rd jan as it 1st as 2nd jan 2023 was a public holiday .

It shlould exclude weekedends and Public holidays and show .
Dimension- Trend_Rpeort Date

The value till nov 2022 is fine . However, for Dec 2022 closing value should take the opening value for Jan 2023 .

thanks

[Aamer_17]

Hi, 

can you please try with networkdays() function in Data load editor.

Hope this will work.

Thanks,

[Aspiring_Developer]

Hi ,

For Network Days , we need two dates . But here I want to implement it on the single date i.e Report Date .

Thanks