Forum Discussion

powerbinewbie26's avatar
powerbinewbie26
Icon for Helper I rankHelper I
3 years ago

Track outstanding tasks per dataset source based on due date/status

I want to track outstanding tasks per dataset source based on due date/status. Sheet: Appended_DataSet Data Set Source Due Date Status S1 16-Jul-23 In Progress S2 1-Aug-23 In Progres...
Need Help
Tips and Tricks
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
3 years ago

Hi, 

Please check the below picture and the attached pbix file.

 

 

 

expected result measure: =
VAR _today =
    TODAY ()
VAR _t =
    FILTER ( Data, Data[Due Date] > _today && Data[Status] <> "Completed" )
RETURN
    COUNTROWS ( _t )
  • powerbinewbie26's avatar
    powerbinewbie26
    Icon for Helper I rankHelper I
    3 years ago

    Hi Jihwan_Kim thank you so much for your help! So i've done as you've suggested and though it does return a value - it seems to be an incorrect value.  In the snip I attached you can see the status indicated Not Started (something other than Completed) and the Final Due Date is before today's date but all of these have not been flagged as outstanding -any advice?

    outstanding measureDashboard outstanding item card with incorrect value

    I also attached the replica of your example - thank you!! 

    • powerbinewbie26's avatar
      powerbinewbie26
      Icon for Helper I rankHelper I
      3 years ago

      Hi Jihwan_Kim - wanted to follow up with you and see if you could help with this issue on your solution! 🙂

    • powerbinewbie26's avatar
      powerbinewbie26
      Icon for Helper I rankHelper I
      3 years ago

      Hi Jihwan_Kim - wanted to follow up with you and see if you could help with this issue on your solution! 🙂