Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
When data gets from Google Analytics its automatically create Datasets, Reports and Dashboards in Power BI web
In datasets we have Fields -> Overview -> DaysFromToday item.
From Power BI Desktop when I try to pull the data from Google Analytics it retrivies the raw data.
So how to do calculation to get the DaysFromToday item and client wants to show the data for last 24hours. Please tell the steps for both.
Best,
Nagarjun K
9986740402
Solved! Go to Solution.
I have no idea on what your GA dataset is like, according to the names, I think you could create two calculated columns as below.
DaysFromToday = DATEDIFF('Table'[date],TODAY(),DAY) isInLast24hours = IF(DATEDIFF('Table'[date],NOW(),HOUR)<24,"Y","N")
The use the column isInLast24hours as a filter.
I have no idea on what your GA dataset is like, according to the names, I think you could create two calculated columns as below.
DaysFromToday = DATEDIFF('Table'[date],TODAY(),DAY) isInLast24hours = IF(DATEDIFF('Table'[date],NOW(),HOUR)<24,"Y","N")
The use the column isInLast24hours as a filter.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
2 | |
2 | |
1 | |
1 |