Forum Discussion

anadavalos's avatar
anadavalos
Frequent Visitor
7 years ago
Solved

adding column for distinct orders

column = calculate(SUM('Calendar for 5 day'[WorkDay]),filter('Calendar for 5 day',and('Calendar for 5 day'[Date]>orders[Order Date], 'Calendar for 5 day'[Date]<=Orders[shipped date])))   I am havin...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    7 years ago

    anadavalos ,

     

    Have you solved your issue by now? If you have, could you please help mark the correct answer to finish the thread? Your contribution will be much appreciated.

     

    Regards,

    Jimmy Tao

v-yuta-msft's avatar
v-yuta-msft
Community Support
7 years ago

anadavalos ,

 

Suppose the two tables have relationship with each other, you may try measure below:

column =
CALCULATE (
    SUM ( 'Calendar for 5 day'[WorkDay] ),
    FILTER (
        'Calendar for 5 day',
        AND (
            'Calendar for 5 day'[Date] > RELATED ( orders[Order Date] ),
            'Calendar for 5 day'[Date] <= RELATED ( Orders[shipped date] )
        )
    )
)

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.