Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Solved! Go to Solution.
Try:
Working Days Old =
VAR StartDate =
CALCULATE (
MIN ( 'FACT - ISG'[Date of Receipt] ),
'FACT - ISG'[Counted] <> "Not Counted"
)
VAR EndDate =
MAX ( 'FACT - ISG'[Date] )
VAR Result =
CALCULATE (
COUNTROWS ( 'DIM - Date Table' ),
DATESBETWEEN ( 'DIM - Date Table'[Date], StartDate, EndDate ),
'DIM - Date Table'[IsWorkingDay] = 1,
'DIM - Date Table'[IsHoliday] = 0
)
RETURN
Result
I've removed all ('DIM - Date Table')). If you mark the table as a date table that is taken care of for you.
Formatting wise download DAX Studio and it'll do it for you or use DAX Formatter by SQLBI
Try:
Working Days Old =
VAR StartDate =
CALCULATE (
MIN ( 'FACT - ISG'[Date of Receipt] ),
'FACT - ISG'[Counted] <> "Not Counted"
)
VAR EndDate =
MAX ( 'FACT - ISG'[Date] )
VAR Result =
CALCULATE (
COUNTROWS ( 'DIM - Date Table' ),
DATESBETWEEN ( 'DIM - Date Table'[Date], StartDate, EndDate ),
'DIM - Date Table'[IsWorkingDay] = 1,
'DIM - Date Table'[IsHoliday] = 0
)
RETURN
Result
I've removed all ('DIM - Date Table')). If you mark the table as a date table that is taken care of for you.
Formatting wise download DAX Studio and it'll do it for you or use DAX Formatter by SQLBI