Forum Discussion

gpapasara's avatar
gpapasara
Frequent Visitor
7 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

gpapasara's avatar
gpapasara
Frequent Visitor
7 years ago

Thank you for your interest :)

 

You will find below the 2 tables that I have. The table 2 is calculated from table oneand what I would like to have now is one the first table next to each date the averages that I have calculated in the 2nd one so if I have the click averege fro example for the 1st January it will be 42.795 on every entry that is 01/01/2018 on the first table.

 

I don't know if I explained that clearly, if not please let me know and I will try again :)

Table1ITable2

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 :)