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!

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!

Highlighted
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

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
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 69 members 1,043 guests
Please welcome our newest community members: