topic Re: Track outstanding tasks per dataset source based on due date/status in DAX Commands and Tips

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

powerbinewbie26 — Tue, 18 Jul 2023 23:47:16 GMT

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 Progress
S3	17-Jul-23	Completed

What dax expression can I use with my appended data set to say something like this: In my appended DataSet, count the rows in column 'DataSet Source' and calculate the # of rows(tasks) that are past the 'due date' and are not 'completed' based on today's date - I ideally want to have them displayed on the visual cards. (In the data set above row 2 would be flagged as past due given today's date Jul 18) I hope you don't mind, I tagged a few users because I saw that you had much experience with the DAX expressionsJihwan_Kim OwenAuger johnt75 thanks so much in advance!

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

Jihwan_Kim — Wed, 19 Jul 2023 03:12:58 GMT

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 )

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

powerbinewbie26 — Tue, 25 Jul 2023 18:01:47 GMT

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?

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

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

powerbinewbie26 — Tue, 01 Aug 2023 17:43:13 GMT

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

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

powerbinewbie26 — Tue, 01 Aug 2023 17:43:14 GMT

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