cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Super User
Super User

Re: Calculating Max and Averages across tables

@PaulHallam hang on a sec, i think i just looked at time and get 3 rooms but based on date and time I think I will get 2






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos Smiley Happy
Feel free to email me with any of your BI needs.





Super User
Super User

Re: Calculating Max and Averages across tables

@PaulHallam isn't it following will return 3

 

image.png






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos Smiley Happy
Feel free to email me with any of your BI needs.





Highlighted
PaulHallam Regular Visitor
Regular Visitor

Re: Calculating Max and Averages across tables

There are only 2 rooms listed Room A and Room B, anything without a Room Name is not a Room. Perhaps i should have left these blank

Super User
Super User

Re: Calculating Max and Averages across tables

@PaulHallam ok make sense, will do.






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos Smiley Happy
Feel free to email me with any of your BI needs.





Super User
Super User

Re: Calculating Max and Averages across tables

@PaulHallam I had made the calculation for #1, but not sure about others, could you please put all this in excel sheet sample data dn the calculations, it will help to get this going otehrwise there will be lot of back and forth.






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos Smiley Happy
Feel free to email me with any of your BI needs.





PaulHallam Regular Visitor
Regular Visitor

Re: Calculating Max and Averages across tables

I have resaved the spreadsheet with the calculations and explanation on,

Thansk for looking at this for me

PaulHallam Regular Visitor
Regular Visitor

Re: Calculating Max and Averages across tables

Any luck with these mesures guys?

Helpful resources

Announcements
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.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 227 members 2,750 guests
Please welcome our newest community members: