Forum Discussion
Power BI Report using Google Analytics data
Create a Measure to Count Entries Within the Last 30 Minutes
CountLast30Minutes =
COUNTROWS(
FILTER(
YourTable,
YourTable[Minutes] <= 30
)
)you can place it in a card visual to display the count of entries within the last 30 minutes.
Your Kudos/Likes are much appreciated!
If this post helps, please consider Accepting it as the solution to help the other members find it more quickly.
Regards,
Kedar Pande
www.linkedin.com/in/kedar-pande
I think I will need to add a measure to show data for last 30 minutes first. Can you help me with that please?
Create a new column:
IsWithinLast30Minutes =
IF(
YourTable[Minutes] > 30,
1,
0
)
Now, apply a visual filter: Drag the IsWithinLast30Minutes column to the Filters pane and set it to show only 1
Thanks Kedar_Pande . Also how can I display the total active users as below
My Power BI report looks like this at the moment
Create a Measure to Count Entries Within the Last 30 Minutes
CountLast30Minutes =
COUNTROWS(
FILTER(
YourTable,
YourTable[Minutes] <= 30
)
)you can place it in a card visual to display the count of entries within the last 30 minutes.
Your Kudos/Likes are much appreciated!
If this post helps, please consider Accepting it as the solution to help the other members find it more quickly.
Regards,
Kedar Pande
www.linkedin.com/in/kedar-pande