Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

table time measure

 

 

 

Hi,

 

I need Help.!

 

First of all this is my database looks like

I am ayalsis project schedule with previous revision schedule. how much the plan got changed.

 

I want to add 4 new columns. 1 for colouring red if the both dates btw 19-April and 19-Feb are not same but green.

and another for showing how many days of differency the dates have. (ex +3, -4...) for start and finish.

 The stardard date will be  19-Apr.

 

thanks,

Need Help
Show and Tell
Tutorial Requests
  • v-yuta-msft's avatar
    v-yuta-msft
    7 years ago

    Anonymous ,

     

    You may create two calculate columns using DAX like pattern below:

    Color =
IF (
Table[Plan Start] >= DATE ( 2019, 2, 1 )
&& Table[Plan Start] <= DATE ( 2019, 4, 30 ),
"Red",
"Green"
)

Days =
DATEDIFF ( Table[Plan Start], Table[Plan Finish], DAY )

    Community Support Team _ Jimmy Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

1 Reply

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    7 years ago

    Anonymous ,

     

    You may create two calculate columns using DAX like pattern below:

    Color =
IF (
Table[Plan Start] >= DATE ( 2019, 2, 1 )
&& Table[Plan Start] <= DATE ( 2019, 4, 30 ),
"Red",
"Green"
)

Days =
DATEDIFF ( Table[Plan Start], Table[Plan Finish], DAY )

    Community Support Team _ Jimmy Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.