Forum Discussion

amaoa's avatar
amaoa
Helper II
6 years ago
Solved

Ontrack DAX Expression

Hello All, So I wrote the DAX expressions for the different task status count by date. But my Ontrack expression is not all inclusive or not capturing all the different counts of tasks status dates ...
Need Help
  • amaoa's avatar
    amaoa
    6 years ago

    I added more details to my original question. I guess I was not clear enough.

    I already have a column that shows status as shown in the two images. I just need to count how many task is Ontrack. I tried writing an expression based on the dates and % comp, but I guess I could have just written a new measure to count the Status of "Ontrack" tasks instead of trying to use the dates and % comp columns. Thanks

amitchandak's avatar
amitchandak
Super User
6 years ago

amaoa , The definition of not started and Late has overlap with on time.

 

Try if this can work, new column

switch (True(),
[TaskPercentComplete] = 1 , "Complete",
TaskStartDate<TODAY() && TaskPercentComplete>0 && TaskFinishDate>TODAY() , "Ontime",
AND(TaskStartDate>TODAY(), TaskFinishDate>TODAY()) , "Not Started",
"Late"
)

 

New column for count of Ontime

switch (True(),
[TaskPercentComplete] = 1 , 0,
TaskStartDate<TODAY() && TaskPercentComplete>0 && TaskFinishDate>TODAY() , 1,
0
)

  • amaoa's avatar
    amaoa
    Helper II
    6 years ago

    I added more details to my original question. I guess I was not clear enough.

    I already have a column that shows status as shown in the two images. I just need to count how many task is Ontrack. I tried writing an expression based on the dates and % comp, but I guess I could have just written a new measure to count the Status of "Ontrack" tasks instead of trying to use the dates and % comp columns. Thanks