Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

New Member

DAX To find the UnReleased Order for Production - Line Chart

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.

Super User
Super User

@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.




If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?

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




Helpful resources


Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.