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

     

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.