Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have this excel sheet see below:
I would like to show the weekly average clicks per UserID (all clicks figured up, by User ID) on a weekly basis.
Can anyone support me on this topic?
Thanks in advance! Much appreciated!
Regards,
Paul
Solved! Go to Solution.
To calculate the weekly average clicks per UserID in Power BI using DAX, you can follow these steps:
Here's how you can do it:
WeekNumber = WEEKNUM('YourTable'[Week ending date])
Create a measure to calculate the total clicks per UserID:
TotalClicks = SUM('YourTable'[View on Pages])
Create another measure to calculate the average clicks per UserID per week:
AverageClicksPerWeek =
AVERAGEX(
SUMMARIZE(
'YourTable',
'YourTable'[User ID],
'YourTable'[WeekNumber],
"TotalClicks", [TotalClicks]
),
[TotalClicks]
)
This measure calculates the total clicks per UserID for each week, then calculates the average of those totals across all weeks.
Once you have created these measures, you can add them to your visualizations to display the average clicks per UserID on a weekly basis.
Make sure to replace 'YourTable' with the name of your table in Power BI.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
In case there is still a problem, please feel free and explain your issue in detail, It will be my pleasure to assist you in any way I can.
To calculate the weekly average clicks per UserID in Power BI using DAX, you can follow these steps:
Here's how you can do it:
WeekNumber = WEEKNUM('YourTable'[Week ending date])
Create a measure to calculate the total clicks per UserID:
TotalClicks = SUM('YourTable'[View on Pages])
Create another measure to calculate the average clicks per UserID per week:
AverageClicksPerWeek =
AVERAGEX(
SUMMARIZE(
'YourTable',
'YourTable'[User ID],
'YourTable'[WeekNumber],
"TotalClicks", [TotalClicks]
),
[TotalClicks]
)
This measure calculates the total clicks per UserID for each week, then calculates the average of those totals across all weeks.
Once you have created these measures, you can add them to your visualizations to display the average clicks per UserID on a weekly basis.
Make sure to replace 'YourTable' with the name of your table in Power BI.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
In case there is still a problem, please feel free and explain your issue in detail, It will be my pleasure to assist you in any way I can.
Thank you so much, very appreciated!
User | Count |
---|---|
57 | |
22 | |
21 | |
19 | |
16 |
User | Count |
---|---|
87 | |
87 | |
52 | |
37 | |
23 |