Forum Discussion
Help with setting up a formula for sorting and displaying
I want some help with a formula in Power Bi , was wondering if you able to assist .
Here is an example of the data
How do i sort on purchase ,so that all the pages visisted by the IP address are displayed when sorting on packages
SORT by IP Address and Date/Time first. Then highlight the Purchase column and Fill Up.
Remember, you can always delete an applied step in Power Query so no harm in experimenting.
8 Replies
- ToddChitt
Super User
Can you give us a sample of what the output should look like?
Maybe try a simple TABLE visual, and add Purchase, IP address, and a COUNT of some column. That will give you the number of times any one Address was visited for each Purchase.
What are the blank cells in the Purchase column? Should they be FILLED DOWN in Power Query?
ToddChitt
The blank cells in the purchase column explains the behavior and steps the IP addresses does before purchasing, this information is important as I am trying to see their behavior before and after