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

kaushikd's avatar
kaushikd
Resolver II
7 years ago

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)