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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Measure for Average

Hello

 

Maybe you can help. I have tried Quick Measures  and other DAX Measures, but I'm not getting result I want.

 

I have a table and I would like to find the average of how many start time of calls in a period. I have created column in the table that shows if the start time is 12:15 it will fall into the group 12-13. I can find the total amount of time per period in that day, but I would like to see the average.

 

The Graph I am using looks like this

 

            Mon   Tue   Wed   Thu  Fri   Sat   Sun

00-01

01-02

02-03

03-04

 

I would like to drop the measure in here and show the average count of the start times in those periods on those days. 

 

Thanking you in adavnce

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @affan

 

I managed to solve the problem.

 

Thanks for your offer

 

Kind regards

View solution in original post

2 REPLIES 2
affan
Solution Sage
Solution Sage

Hi @Anonymous

 

Can you share a sample of your base data? This will help understanding you requirement

Anonymous
Not applicable

Hi @affan

 

I managed to solve the problem.

 

Thanks for your offer

 

Kind regards

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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