Forum Discussion

ArchStanton's avatar
ArchStanton
Power Participant
4 years ago

Previous Date Offset - DAX Calculated Column

Hi, I have been using the link below to hopefully fix an issue where I need to calculate the DAYSBETWEEN the ActualStartDate & ActualEndDate using a calculated column.    My problem is when the da...
Need Help
Show and Tell
Tutorial Requests
amitchandak's avatar
amitchandak
Super User
4 years ago

ArchStanton ,

New column =

var _1 = maxx(filter(Table, [owner id] = earlier([owner id]) && [Actual end] < earlier([Actual end]) ),[Actual end])

return

if(isblank(_1), networkdays([Case open], [actual start],1) , networkdays(_1 , [actual end],1) )

  • ArchStanton's avatar
    ArchStanton
    Power Participant
    4 years ago

    Thanks for your reply, I'm trying your way in a separate column but get the following error message:

     

    The syntax for 'return' is incorrect. (DAX(maxx(filter(Deferrals, [regardingobjectid] = earlier([regardingobjectid]) && [Actual end] < earlier([Actual end]) ),[Actual end])returnif(isblank(_1), networkdays([Case Received], [actual start],1) , networkdays(_1 , [actual end],1) ))).

     

    I'm not using NETWORKDAYS, instead I have a Date Table that I have already used to calculate how long its been since Case opened (aka Case Received) and ActualEndDate

     

     

    Time in Deferral AP = CALCULATE(
    COUNTROWS('Date Dimension'),
    DATESBETWEEN('Date Dimension'[Date],Deferrals[actualstart],Deferrals[actualend]),'Date Dimension'[Is Working Day] = TRUE(),
    ALL('Date Dimension')
)

     

     (see above) 

     

    Can this be incorporated into your Code do you think?