cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
perplexedDev Frequent Visitor
Frequent Visitor

Average of result grouped by dates

I have a table of the format

Date    Result

4/11     F

4/11     F

4/12     P

4/12     F

4/12     P

 

I need to get the average of pass and fail records per date to plot a chart as below

Date    PassAvg   FailAvg

4/11     0               100%(i.e,2*100/2)

4/12     66.6%       33.3% 

 

How can I achieve this?

1 ACCEPTED SOLUTION

Accepted Solutions
Sean Super Contributor
Super Contributor

Re: Average of result grouped by dates

@perplexedDev

There's 2 ways to do this. I'll give you both because inevitably someone will read this and try to give you the easy way...

 

First (not the way I would do it - but its faster)

You need to write only 1 Measure - and create a Matrix - place fields as in the picture!

Matrix - Quick.png

 

Second you have to write 5 simple Measures but it gives you more flexibilty later on... for other visualiazations including charts

Table.png

I may post a chart later which you can't do with the first method

Hope this helps!

View solution in original post

5 REPLIES 5
Sean Super Contributor
Super Contributor

Re: Average of result grouped by dates

@perplexedDev

There's 2 ways to do this. I'll give you both because inevitably someone will read this and try to give you the easy way...

 

First (not the way I would do it - but its faster)

You need to write only 1 Measure - and create a Matrix - place fields as in the picture!

Matrix - Quick.png

 

Second you have to write 5 simple Measures but it gives you more flexibilty later on... for other visualiazations including charts

Table.png

I may post a chart later which you can't do with the first method

Hope this helps!

View solution in original post

perplexedDev Frequent Visitor
Frequent Visitor

Re: Average of result grouped by dates

The secod solution works perfectly. I had one question though, how did you add the percentage sign for Avg measures?

Sean Super Contributor
Super Contributor

Re: Average of result grouped by dates

Modeling Tab => Format: => select Percentage

Format.png

Highlighted
perplexedDev Frequent Visitor
Frequent Visitor

Re: Average of result grouped by dates

Thank you so much. Sorry for my ignorance,I am new to excel and power BI.

calerof Member
Member

Re: Average of result grouped by dates

Hi,

But what about the dates grouping, in this case by day?

Fernando

 

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 121 members 1,571 guests
Please welcome our newest community members: