Equals

[gpapasara]

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) and have calculated the average per date and now I would like to return to the first table and add a column that will put that average per date to the dates on that.

Does that make any sense to you?

Thanks 🙂

[kaushikd]

I do not see any use of second table here, may be Ihave not understand the requirement. But If you want to store DistinctDate and Avg of something, just create a measure(Average) in the First Table and pull the date and the measure into a visual it will aggregate the Measure for each date(no repetation in the date)

[v-danhe-msft]

Hi @gpapasara,

Could you please post me some sample data and your desired result if possible?

Regards,

Daniel He

[gpapasara]

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 · Accepted solution]

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]

Thank you very much sir, that was a great help 🙂