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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

DAX Formula help

I want to find the following.  How many qty is having end date later than start date (% behind the end date) – Quickly point out which qty is behind with deliveries. How to achieve this via DAX and how to show this as a bar graph

 

 data format is as below

 

Start dateEnd Date Ordered QUANTITYReserved Qty
01/03/202116/08/2021 20002000
01/03/202116/08/2021 40003000
02/03/202101/11/2021 2400024000
01/03/202103/04/2023 90005000
01/03/202103/04/2023 1500015000
01/03/202103/04/2023 1800018000
05/03/202103/04/2023 2700026000
1 REPLY 1
daxer-almighty
Solution Sage
Solution Sage

I'm afraid all the end dates are later than their corresponding start dates.

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.