Forum Discussion

tomasjezek's avatar
tomasjezek
Frequent Visitor
2 years ago
Solved

Data Transformation - Create Milestone Start Date column based on data from two other columns

Hello PBI Community Members,   I would like to ask you to help me (and challenge you a bit) with following data transformation task.   I have a data set where there are Projects and their's Miles...
Need Help
Show and Tell
  • HotChilli's avatar
    HotChilli
    2 years ago

    I used the Index column to make this a bit easier:

    ColumnE = 
var _idx = TableK[Index]
var _proj = TableK[PR]
var _offsetDate = CALCULATE(MAX(TableK[Milestone Completion Date]), FILTER(TableK,  TableK[Index] = _idx -1))
VAR _Result = IF ( TableK[Project Milestone] = "M1", TableK[Project Start Date], _offSetDate  )
RETURN
    _Result
HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
2 years ago

Post that data as text please.

Where is the Project Milestone Index values?  Can you provide the code for that?

PLease show the desired result for Milestone Start Date

  • tomasjezek's avatar
    tomasjezek
    Frequent Visitor
    2 years ago

    Hi,

    I updated my post with required information, but I can not provide the code so far.

    Maybe there will be a solution without a need to use Project Milestone Index. The main focus is to have Milestone Start Date column.

     

    Thank you.