Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

conditional column wrt dates

Problem Statement:         There are 5 columns involved, which are 'Order ID', 'Order Status', 'Desired Part Delivery Date', 'In Shipping Date', 'Order Completed Date'.           I need to create ...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    4 years ago

    Hi Anonymous 

     

    You can first add a new column to flag whether an order ID meets both conditions you mentioned. Then create a measure to calcualte the count. 

     

    Create a new column as below. It returns 1 when the condition is true. 

     

    Then create a measure to count Order IDs whose Flag value is 1. 

    Number Of IDs = CALCULATE(COUNT('Table'[Order ID]), 'Table'[Flag] = 1)

     

    If you want to add filters, it could be 

    Number Of IDs 2 = CALCULATE(COUNT('Table'[Order ID]), 'Table'[Flag] = 1, 'Table'[Order Status] = "Completed")

    or

    Number Of IDs 3 = CALCULATE(COUNT('Table'[Order ID]), 'Table'[Flag] = 1, 'Table'[Order Status] IN {"Completed", "Shipping"})

    Hope it helps. 

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.