Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi,
I am trying to calculate Average in using Measure but not able to get the average with certain date selected.
For eg:
Date Sales
6/1/2021 5465
6/2/2021 5658
6/3/2021 5221
6/4/2021 4547
6/5/2021 12
6/6/2021 22256
6/7/2021 22356
Here if I filter just 3 days (1st June to 3rd June) Average = 5448
Same way, if I filter the date from 3rd June to 7th June than Average = 10878.4
Really appreciate for your help.
Solved! Go to Solution.
https://www.dropbox.com/s/t3gqd6i3hmwom0u/adarshash.pbix?dl=0
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Thank you verymuch for your quick reply, Jihwan
But what I need a unique Average value so that I can do further calculation like:
If average > x then Sales/x value (per each row)
How can show in above table Average = 12.292.75 for each row.
https://www.dropbox.com/s/t3gqd6i3hmwom0u/adarshash.pbix?dl=0
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
https://www.dropbox.com/s/t3gqd6i3hmwom0u/adarshash.pbix?dl=0
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
99 | |
95 | |
88 | |
70 |
User | Count |
---|---|
165 | |
131 | |
129 | |
102 | |
98 |