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.
Hello. i'm in the situation as shown below:
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?
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.
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
Hi @GDavi, Can you send a before and after example with anonymous data so that I can better understand your problem.
Thanks
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 |
---|---|
108 | |
98 | |
81 | |
65 | |
62 |
User | Count |
---|---|
147 | |
116 | |
104 | |
88 | |
65 |