Need to sum year to date by creation date and delivery date

[bstark1287]

Because there are multiple dates within the table I must use the USERELATIONSHIP dax. Here is what I have: 

Total by Create date = CALCULATE([OE],

DATESYTD(

USERELATIONSHIP('Calendar'[Date], Sheet2[CREATE_DATE])))

Note: OE= sum of order qty

[PabloDeheza · Accepted solution]

Hi there!

I would be like this:

CALCULATE(
    [OE]
    DATESYTD( 'Calendar'[Date] ),
    USERELATIONSHIP( 'Calendar'[Date], Sheet2[CREATE_DATE] )
)

Let me know if that helps!

[bstark1287]

That did it, thank you! How could I enter USERELATIONSHIP in this DAX? 

CALCULATE(

    SUM('Sheet2'[ORDER_QTY]),

    FILTER(

        ALLSELECTED('Calendar'[Date]),

        ISONORAFTER('Calendar'[Date], MAX('Calendar'[Date]), DESC)

    )

)

[PabloDeheza]

Just add it as another argument of your calculate expression, as it will enable the indicated relationship for the duration of the calculation. Should be like this:

CALCULATE (
    SUM ( 'Sheet2'[ORDER_QTY] ),
    FILTER (
        ALLSELECTED ( 'Calendar'[Date] ),
        ISONORAFTER ( 'Calendar'[Date], MAX ( 'Calendar'[Date] ), DESC )
    ),
    USERELATIONSHIP ( 'Calendar'[Date], Sheet2[CREATE_DATE] )
)