
Im on the way to finish my BI Dashboard, nevertheless Im Stuck a little bit!!
Im Trying to get Date of Goals in Dataverse (Up to know without successes!) Logic is to have Variance day between Goal Date vs Task Finish date.
I check already all fields into msdyn_projectgoal and can not get it.
I appreciate your support .
VarianceDays =
DATEDIFF (
'ProjectTask'[PlannedFinish],
'ProjectTask'[ActualFinish],
DAY
)