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

Preparing for a certification exam? Ask exam experts all your questions on May 15th. Register now.

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
PBIApril_Carousel

Power BI Monthly Update - April 2025

Check out the April 2025 Power BI update to learn about new features.

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

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