table time measure

[Anonymous]

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,

[v-yuta-msft · Accepted solution]

@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.