Forum Discussion

icrmzgc's avatar
icrmzgc
Frequent Visitor
2 years ago
Solved

To add a stage column

Thank you for your help. I would like to refer to table T_Reference and change table T_From to table T_To. (I want to add a stage column) Is it possible with DAX or PowerQuery? The sample file ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi  icrmzgc ,

     

     

    Here are the steps you can follow：

    1. Create calculated column.

    Stag =
MINX(
    FILTER(ALL(T_Reference),    'T_Reference'[Date]>=EARLIER('T_From'[Date])&&'T_Reference'[Project]=EARLIER('T_From'[Project])),'T_Reference'[Stage])

     

    2. Result:

     

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

icrmzgc's avatar
icrmzgc
Frequent Visitor
2 years ago

Hello amustafa.
Thank you for your answer and sample file.
I didn't know that you could specify two parameters with Table.NestedJoin, so I learned a lot.

However, unfortunately, some of the ideas I received are not able to set the stage.
I also want to set the Stage for the 10 items in red.