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,

Could you please post me some sample data 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 :)