DAX To find the UnReleased Order for Production - Line Chart

[rncsalmankhan]

Hi, I am working on creating charts for a production data.

The table has below values. Released means the order is released to production team from sales team. 

Order ID - Unique value

Order Date

Order Value

Order Quantity

IsReleased (1 means released to production. 0 means still with sales team and unreleased status)

Release date - Contains the date on which the order released from sales to production.

The date fields are connected to DimDate table with Order Date as active and Release date as inactive.

I can make the Order created and Released order value trend chart based on the Order date, Release date and IsReleased flag. It works fine as expected for current day and past.

But how can I get the unreleased order value trend chart ? Could you please support with DAX.

Example - The chart should give me the value of unreleased orders on a specific past date. (Example - Last month 28th day what was the UnReleased value). 

Please help.

[TheoC]

@rncsalmankhan can you please add some dummy data to support your request, possibly a visual representation of what you're wanting as an output as well.

Thanks in advance.

Theo

[rncsalmankhan]

I need to build something like this. On a specific date what was the pending unreleased orders.