Forum Discussion

gpapasara's avatar
gpapasara
Frequent Visitor
8 years ago
Solved

Equals

Hi people :)   I have 2 tables and I would like to populate from one to the other. I have on the first dates and for each date lots and lots of entries, in the second I have made a Distinct(date) ...
Need Help
  • v-danhe-msft's avatar
    v-danhe-msft
    7 years ago

    Hi gpapasara,

    Based on my test, you could use the formula in your table 1:

    Clicks avg = CALCULATE(AVERAGE(Table1[Click]),FILTER('Table1','Table1'[Date]=EARLIER(Table1[Date])))

    Result:

    If I mistunderstand you, could you please share me the pbix file and your desired result if possible?

     

    Regards,

    Daniel He

v-danhe-msft's avatar
v-danhe-msft
Microsoft Employee
7 years ago

Hi gpapasara,

Based on my test, you could use the formula in your table 1:

Clicks avg = CALCULATE(AVERAGE(Table1[Click]),FILTER('Table1','Table1'[Date]=EARLIER(Table1[Date])))

Result:

If I mistunderstand you, could you please share me the pbix file and your desired result if possible?

 

Regards,

Daniel He

gpapasara's avatar
gpapasara
Frequent Visitor
7 years ago

Thank you very much sir, that was a great help :)