Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Alright.... So I want to create a measure that will sum up the number of pages visited per session.
I want to sum the count of the URL column for each UnqSession, and have the ability to average it over time or industry (etc)
I can lay it out in PBI Table and it looks like this, but I need measures so I can look at averages by month, etc..
Solved! Go to Solution.
@bigfun ,
Count till Date avg above that
AverageX(Values(Table[Date]), Calculate(Distinctcount(Table[PageID])))
Count till Month avg above that
AverageX(Values(Table[Month Year]), Calculate(Distinctcount(Table[PageID])))
you can use count in place of Distinctcount
Hi,
In the Query Editor, seperate the Date and time stamp in 2 columns from the Eventtime column. Create a Calendar Table with calculated column formulas for Year, Month name and Month number. Sort the Month name by the Month number. Create a relatinoship (Many to One and Single) between the Event Date column and Date column of the Calendar Table. To your visual, drag Year and Month name from the Calendar Table.
Write this measure
Measure = counta(Data[URL])
Hope this helps.
Thank y'all so so much
Hi,
In the Query Editor, seperate the Date and time stamp in 2 columns from the Eventtime column. Create a Calendar Table with calculated column formulas for Year, Month name and Month number. Sort the Month name by the Month number. Create a relatinoship (Many to One and Single) between the Event Date column and Date column of the Calendar Table. To your visual, drag Year and Month name from the Calendar Table.
Write this measure
Measure = counta(Data[URL])
Hope this helps.
@bigfun ,
Count till Date avg above that
AverageX(Values(Table[Date]), Calculate(Distinctcount(Table[PageID])))
Count till Month avg above that
AverageX(Values(Table[Month Year]), Calculate(Distinctcount(Table[PageID])))
you can use count in place of Distinctcount
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
89 | |
83 | |
76 | |
64 |
User | Count |
---|---|
142 | |
112 | |
98 | |
98 | |
94 |