I have a DAX to calculate the operating days considering the store open/close date.
the below is working fine in Excel 2017. but getting error when the file is opened using Excel 2013
OpDaysLY:=FORMAT (
SUMX (
ADDCOLUMNS (
SUMMARIZE (
STORELIST,
STORELIST
the below is working fine in Excel 2017. but getting error when the file is opened using Excel 2013
OpDaysLY:=FORMAT (
SUMX (
ADDCOLUMNS (
SUMMARIZE (
STORELIST,
STORELIST
Code:
,
STORELIST[HD Start Date],
STORELIST[End Date],
"NSt", DATE ( 2017, MONTH ( MIN ( 'calendar'[DATE] ) ), 1 ),
"NEnd", MAX ( 'calendar'[DATE] )-365
),
"x", IF ( [HD Start Date] > [NEnd], [HD Start Date] - 1, MIN ( [End Date], [NEnd] ) )
- IF ( [End Date] <= [NSt], [End Date] + 1, MAX ( [NSt], [HD Start Date] ) )
+ 1
),
[x]
),
"#"
)
can anyone suggest equivalent DAX in Excel 2013