Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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,...
General Comment
Need Help
Show and Tell
Tips and Tricks
  • v-diye-msft's avatar
    v-diye-msft
    6 years ago

    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's avatar
v-diye-msft
Community Support
6 years ago

Hi Anonymous 

 

You might consider creating pbix file that will contain some sample data, upload the pbix to onedrive or dropbox and share the link to the file. Please do not forget to describe the expected results based on this sample data.