Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 🙂
Solved! Go to 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
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)
Hi @gpapasara,
Could you please post me some sample data and your desired result if possible?
Regards,
Daniel He
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 🙂
I
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
Thank you very much sir, that was a great help 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |