Forum Discussion

etane's avatar
etane
Icon for Helper V rankHelper V
1 year ago
Solved

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.

4 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Icon for Super User rankSuper User
    1 year ago

    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.

     

     

     

     

    • etane's avatar
      etane
      Icon for Helper V rankHelper V
      1 year ago

      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.

      • v-menakakota's avatar
        v-menakakota
        Icon for Community Support rankCommunity Support
        1 year ago

        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