Forum Discussion

SMITHY10283's avatar
SMITHY10283
Regular Visitor
2 years ago

Create calculated column

Hi, I need help in creating a calculated column and don't know where to start.    So I have a dataset with Portfolio, Project, Reporting Date, Status as columns.    Portfolio Project Reporti...
Need Help
amitchandak's avatar
amitchandak
Super User
2 years ago

SMITHY10283 , Try meausre like , and find the file attcahed

 

Progress1 = 
var _min = Maxx(filter(Projects, Projects[project] = earlier(Projects[Project]) && Projects[Status] = "Completed" && [Reporting Date] < earlier([Reporting Date])) , [Reporting Date])
var _min1 = if(ISBLANK(_min) , minx(filter(Projects, Projects[project] = earlier(Projects[Project])  && [Reporting Date] < earlier([Reporting Date])) , [Reporting Date]) , minx(filter(Projects, Projects[project] = earlier(Projects[Project])  && [Reporting Date] >_min && [Reporting Date] < earlier([Reporting Date])) , [Reporting Date]))
return
if(Projects[Status] = "Completed", DATEDIFF(_min1, [Reporting Date], MONTH),0
)