Calculate operating days.

[sadath]

Hi All,

how can calculate the operating days

STORELIST[Start Date] is the store opened date
STORELIST[End Date] is the store close date
[NEnd] is Max(Calendar[Date])
[NSt] is Min(Calendar[Date])

how can more simply calculate the operational number of days between any selected date, is there any simpler way than the below DAX?

OpDays18:=SUMX( SUMMARIZE(
STORELIST,
STORELIST

,
                STORELIST[Start Date],
                STORELIST[End Date],
                  "x", IF ( VALUES(STORELIST[Start Date]) > [NEnd], VALUES(STORELIST[Start Date]) - 1, 
                      IF(values(STORELIST[End Date])<[NEnd],values(STORELIST[End Date]),[NEnd]) )-
                      IF ( values(STORELIST[End Date]) <= [NSt], values(STORELIST[End Date])+1,if([NSt]>STORELIST[Start Date],)
                      [Nst],STORELIST[Start Date]) ) +1
                    ,[x])

 

[Matt Allington]

Read my article here. I think the pattern will work for you. https://powerpivotpro.com/2016/12/how-many-working-days-has-an-employee-been-off-work/