User Profile
Laska02
New Member
Joined 3 years ago
User Widgets
Contributions
Re: Average
Thank you for your response, I've been on vacation, hence the late response. Unfortunately this is not the solution. I have already applied the method you recommend and also incorporated it into the example, this is table 2. For Monday, PowerBi then divides the number of customers by the product of the number of Mondays and the number of measurement moments). Do you have another idea?Average
Hello, I have problems getting the right average. It's about customer counters where I have several measurements every day. I would like to have an average per weekday (Monday, Tuesday, etc) for an average week. I have some data: - date - time - values See table below The table is: If I now create a 2nd table in which I let PowerBi determine the averages, it goes wrong. PowerBi divides the number of customers by the product of the number of measurement moments and the number of days. The average for Monday (daynumber 1), for example, should be 152. Please advise, thanks in advance.
