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.
User | Count |
---|---|
123 | |
96 | |
89 | |
73 | |
63 |
User | Count |
---|---|
138 | |
115 | |
111 | |
98 | |
95 |