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

amustafa's avatar
amustafa
Solution Sage
2 years ago

Hi icrmzgc , you need to define the join (relationship) between T_Reference and T_From table. You have project codes with different milestones and dates. Your T_From table just have Project codes. I used the Project codes and the Date combo in Power Query to get what you might really need. See the files in my shared drive link below.

 

Project Cost and Stage

 

If I answered your question, please mark this thread as accepted and Thums Up!
Follow me on LinkedIn:
https://www.linkedin.com/in/mustafa-ali-70133451/