Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!

Reply
GooseHelpful199
Helper I
Helper I

Creating a Measure that can calculate timeframe based on slicer filters?

‎08-01-2023 06:34 AM

I have some Sales data that is provided with dates, and I have presented that information on a page I made with Year/Month filters.

Someone asked me if I can create visuals that provides the Sales data in an Average Daily form. Is there a way that I can create a measure that can calculate this for me? It seems I need to find a way to divide Sum of Sales by the Difference in Days between the first and last dates of my filtered timeframe, but I have no idea if its even possible for a measure to obtain this date info from slicers.

If anyone has any suggestions on whether this is possible or if there is a better alternative that would be really appreciated.

Labels:
Message 1 of 2
390 Views
0
1 ACCEPTED SOLUTION
Idrissshatila
Super User
Super User

‎08-01-2023 06:37 AM

Hello @GooseHelpful199 ,

 

check if this blog will help you with your case https://blog.enterprisedna.co/calculate-average-sales-in-power-bi/

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!


View solution in original post

Message 2 of 2
386 Views
0
1 REPLY 1
Idrissshatila
Super User
Super User

‎08-01-2023 06:37 AM

Hello @GooseHelpful199 ,

 

check if this blog will help you with your case https://blog.enterprisedna.co/calculate-average-sales-in-power-bi/

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!


Message 2 of 2
387 Views
0

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

Vote for your favorite vizzies from the Power BI World Championship submissions!

Sticker Challenge 2026 Carousel

Join our Community Sticker Challenge 2026

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

January Power BI Update Carousel

Power BI Monthly Update - January 2026

Check out the January 2026 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All