Forum Discussion
Need a help
Hello everyone! I do not know how to put into second table "how_likely_are_you_to" data. If the year is 2019 then from the first table I want to take latest available value in 2019, in this case 7,...
Hi Anonymous
Let me know if you'd like to get below results:
1. Add the calculated column in the first table:
Year = YEAR('Table'[CreatedTime])2. Add the measure:
Measure 2 = CALCULATE(MAX('Table'[CreatedTime]),ALL('Table'),VALUES('Table'[Year]))3. Manage the relationship between table1 and table2:
4. Then you get the latest time in table 2:
v-diye-msft
Community Support
Community SupportHi Anonymous
Let me know if you'd like to get below results:
1. Add the calculated column in the first table:
Year = YEAR('Table'[CreatedTime])2. Add the measure:
Measure 2 = CALCULATE(MAX('Table'[CreatedTime]),ALL('Table'),VALUES('Table'[Year]))3. Manage the relationship between table1 and table2:
4. Then you get the latest time in table 2: