Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Google analytics User Dimension

im new to power query ,  I Am currently trying to load the User dimension from Google analitics to power bi  with the Date dimension , my problem is in the power query editor with the below query  ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    i think i figured it out there is no data from 2015 so it gives 0 

     

    if i add the filter  below i get the column users populated and with this i can create the measures users 7 days etc 

    = Table.SelectRows(#"Sorted Rows", each ([Date] >= #date(2016, 09, 01)))
Anonymous's avatar
Anonymous
Not applicable
6 years ago

i think i figured it out there is no data from 2015 so it gives 0 

 

if i add the filter  below i get the column users populated and with this i can create the measures users 7 days etc 

= Table.SelectRows(#"Sorted Rows", each ([Date] >= #date(2016, 09, 01)))