Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
adarshashrestha
New Member

CALCULATE Average depends on Date selected

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.

1 ACCEPTED SOLUTION
Jihwan_Kim
Super User
Super User

Picture1.png

 

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.


Visit my LinkedIn page by clicking here.


Schedule a meeting with me to discuss further by clicking here.

View solution in original post

3 REPLIES 3
adarshashrestha
New Member

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)

Capture.JPG

How can show in above table Average = 12.292.75 for each row.

 

 

Picture3.png

 

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.


Visit my LinkedIn page by clicking here.


Schedule a meeting with me to discuss further by clicking here.

Jihwan_Kim
Super User
Super User

Picture1.png

 

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.


Visit my LinkedIn page by clicking here.


Schedule a meeting with me to discuss further by clicking here.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.