Skip to content

Instantly share code, notes, and snippets.

@shermozle

shermozle/Google Analytics date parsing in PowerBI

Created August 30, 2022 04:57
Show Gist options
  • Save shermozle/8839d14e814c54857104bae6ec61e462 to your computer and use it in GitHub Desktop.
Save shermozle/8839d14e814c54857104bae6ec61e462 to your computer and use it in GitHub Desktop.
Download ZIP
Google Analytics outputs YYYYMMDD dates in its custom reports which Excel and PowerBI can't deal with easily. This handles it.
Raw
Google Analytics date parsing in PowerBI
Parsed_Date = DATE(LEFT('GA pageviews'[Date], 4), MID('GA pageviews'[Date], 5, 2), RIGHT('GA pageviews'[Date], 2))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment