Forum Discussion

SMITHY10283's avatar
SMITHY10283
Regular Visitor
2 years ago
Solved

Create calculated column based on value in another 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
    2 years ago

    SMITHY10283 , Update one and file attached 

        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
    )
SMITHY10283's avatar
SMITHY10283
Regular Visitor
2 years ago

Sorry didn't work, I have edited my original post

  • amitchandak's avatar
    amitchandak
    Super User
    2 years ago

    SMITHY10283 , Update one and file attached 

        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
    )