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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
etane
Resolver I
Resolver I

Measure for Calculating Days Outstanding

Hello.

I am looking for a measure that calculates the outstanding number of days an Order fulfilled without a PO#.

Here are the parameters for a measure I am looking for:

 

If Event_Status = "Complete" and PO_Number is blank then calculate Date Difference between Today() and Order Date else blank

 

Working file here: Link

 

Thanks.

1 ACCEPTED SOLUTION
Jihwan_Kim
Super User
Super User

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file if it suits your requirement.

 

Jihwan_Kim_0-1756348707105.png

 

 

 


If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

View solution in original post

4 REPLIES 4
Jihwan_Kim
Super User
Super User

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file if it suits your requirement.

 

Jihwan_Kim_0-1756348707105.png

 

 

 


If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

@Jihwan_Kim 

 

If I am observing the pbix you attached correctly, the only thing you did was drag the measure I wrote into the table?  Just want to verify that because the same measure doesn't work in my app on my pc.  I suspect the desktop app version I have is buggy.  And, perhaps my solution is to roll back to my year old version of the app.

Hi @etane ,

Thanks for reaching out to the Microsoft fabric community forum. 


Thank you for the update, make sure you’re on the latest release of Power BI Desktop. Sometimes measures behave differently across builds.

If I misunderstand your needs or you still have problems on it, please feel free to let us know.   

Best Regards, 
Community Support Team  




@v-menakakota So, I recently upgraded to the latest version and I started experiencing issues.  DAX don't work.  WebView2 crash.  My IT already installed and reinstalled PBI app and Webviewer and still same issue.  Tried July 2025 version and less Webviewer crashes but still same issue.  Just downgraded to June 2024 version, and the DAX mentioned above does work in this file.  

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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