Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi,
I have Column A and Column B with two references.
Columns A and B talk about the same thing.
Column A is the current reference.
Column B is the previous reference of column A.
Column C gives the date of reference A.
I am looking to have a column D which gives the date of the reference B based on column C.
An example of what I have in mind:
Thanks !
Can you help me please ?
Solved! Go to Solution.
Hi , @MarcoCast
Here are the steps you can refer to :
(1)We can click "Custom Column" and enter this:
(x)=> if List.IsEmpty( Table.SelectRows(#"Changed Type",(y)=> y[A]=x[B])[C] ) then null else
Table.SelectRows(#"Changed Type",(y)=> y[A]=x[B])[C]{0}
(2)Then we can meet your need:
Second, you need to delete the "each" if it exist !
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @v-yueyunzh-msft ,
Thanks for you time and for help, It work perfectly !
I don't clearly understand the command but i will delve deeper into the subject.
If anyone passes by looking for similar help, maybe we can add that in the command, #"Changed Type" refers to the previous query and must be changed depending on our processing.
(x)=> if List.IsEmpty( Table.SelectRows(#"Changed Type",(y)=> y[A]=x[B])[C] ) then null else Table.SelectRows(#"Changed Type",(y)=> y[A]=x[B])[C]{0}
Best Regards,
Marco
Hi , @MarcoCast
Yes , the #"Changed Type" refers to the previous query . You can use other step who has the [A],[B],[C] columns also ,and you can also create a fixed name to solve this problem.
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi , @MarcoCast
Here are the steps you can refer to :
(1)We can click "Custom Column" and enter this:
(x)=> if List.IsEmpty( Table.SelectRows(#"Changed Type",(y)=> y[A]=x[B])[C] ) then null else
Table.SelectRows(#"Changed Type",(y)=> y[A]=x[B])[C]{0}
(2)Then we can meet your need:
Second, you need to delete the "each" if it exist !
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
18 | |
12 | |
10 | |
8 | |
7 |
User | Count |
---|---|
26 | |
15 | |
12 | |
12 | |
10 |