Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
GDavi
New Member

Pivoting a table by date to find the start and end of an event

Hello.  i'm in the situation as shown below:

GDavi_2-1663767745099.png

 

i have 4 columns: 
name 1: a page visited
DateUTC: when it was visited
actionEvent: what has been done
Name 2: who done it
watching data is clare to understand when someone loged in and out from a page. but i dont know how to pivot this table to have a column access and one leave
to have something like this:  
name1, name2, loaded, leave
where leave can be null
can someone help me?

3 REPLIES 3
davehus
Memorable Member
Memorable Member

Hi @GDavi ,

In Power Query move Name 2 to beside name 1.

Select Access Event>Transform>Pivot Column>Select Date from Popup and don't aggregate from advance options.

davehus_0-1663791669694.png

 

Hope this helps

Did I help you today? Please accept my solution and hit the Kudos button.

Hi! i tried this, but unfortunatly it works only if i add a index column.
the final result is me having 4 columns: 
name 1
name 2
Loaded --> with the date of loading and some nulls
Leave --> with date of leaving with some nulls
it still don't pair together the access with his leave (that is not necessarily the next leave in line)
the think i need is similar to this, because i need those 4 columns, but i also need to not have null on the load column and to populate the leave column only with the correct date

davehus
Memorable Member
Memorable Member

Hi @GDavi, Can you send a before and after example with anonymous data so that I can better understand your problem.

 

Thanks 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.