Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi I am using a sharepoint task list to visualize data. I would like to create two additional column to view overdue task and completed task. I got the following error:
Any help will be appreciated
Solved! Go to Solution.
Hi @knishal ,
Maybe this formual
=
VAR _D=DATEDIFF(TODAY(), Tasks[DueDate], DAY )
RETURN
IF(_D<1,"OVERDUE Task",_D)
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @knishal ,
Please try change the type of [DueDate] to Date to fix the error meassage.
Or try this code to create a measure and put it in this visualization
if(max('table'[Duedate]) >today ,1,0)
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@v-chenwuz-msft that works but shows "1" how can I display the amount of days it will be due in?
This is what I use:
@v-chenwuz-msft I currently have this formula which shows the amout of days its due by:
Hi @knishal ,
Maybe this formual
=
VAR _D=DATEDIFF(TODAY(), Tasks[DueDate], DAY )
RETURN
IF(_D<1,"OVERDUE Task",_D)
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
94 | |
86 | |
78 | |
70 | |
63 |
User | Count |
---|---|
114 | |
101 | |
97 | |
66 | |
59 |