Hi,
I'm coming back to you with a question regarding Powerpivot.
Context: I have a log file, which gives me roughly:
date|item_id|status
item_id is a unique identifier of my items.
status can be "created", "deleted" or some other possibilities (such as "edited")
=> I want to look at the number of items created during a given week, minus the items which have been deleted (whatever the deletion date).
I must add that I don't have a dimension table with all item_id available. Moreover each line is not necessarily unique, meaning I have sometimes multiple "deleted" status for the same item.
I'm not sure how to handle such a problem right now, anyone with a clue?
Thanks!
I'm coming back to you with a question regarding Powerpivot.
Context: I have a log file, which gives me roughly:
date|item_id|status
item_id is a unique identifier of my items.
status can be "created", "deleted" or some other possibilities (such as "edited")
=> I want to look at the number of items created during a given week, minus the items which have been deleted (whatever the deletion date).
I must add that I don't have a dimension table with all item_id available. Moreover each line is not necessarily unique, meaning I have sometimes multiple "deleted" status for the same item.
I'm not sure how to handle such a problem right now, anyone with a clue?
Thanks!
Last edited:
