Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowGet certified as a Fabric Data Engineer: Check your eligibility for a 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700. Get started
Hi,
My data looks like below:
This is one table. I have another table with relationship between index and index (one to many). I want to
Index | Value |
A | 300 |
B | 140 |
C | 50 |
How to get this Value column? It have to be calculated as calculated column due to filtering this data.
Solved! Go to Solution.
Hi @Anonymous ,
Here are the steps you can follow:
1. Create calculated column.
Value =
MAXX(FILTER(ALL(Table1),
'Table1'[Index]='Table2'[Index]&&
'Table1'[Date]=MAXX(FILTER(ALL(Table1),'Table1'[Index]=EARLIER('Table1'[Index])),[Date])
),[Value])
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 @Anonymous ,
Here are the steps you can follow:
1. Create calculated column.
Value =
MAXX(FILTER(ALL(Table1),
'Table1'[Index]='Table2'[Index]&&
'Table1'[Date]=MAXX(FILTER(ALL(Table1),'Table1'[Index]=EARLIER('Table1'[Index])),[Date])
),[Value])
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
Try to make a New Column using the following measure:
Column = CALCULATE(MAX('Table1'[Value]),FILTER('Table1','Table1'[Index]='Table2'[Column1]))
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
22 | |
17 | |
16 | |
11 | |
7 |
User | Count |
---|---|
26 | |
25 | |
12 | |
12 | |
12 |