Forum Discussion
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 ...
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
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
Hello, Liu Yang.
Thank you for your reply and file.
It's what I was looking for.
I don't fully understand the DAX style description with my current knowledge, but I would like to be able to understand it.
I'm really thankful to you.