Forum Discussion
Help needed - filter, power queries and pivot
there may be some blank rows in Table1, especially some may have start date but not the end date, so
what did you mean blank start end date in Table1?
They are all filled in the attachment.
And Table1 and Sheet1 are same?
pivot slicer with list of months that allows me to filter the activities that are occurring that month.
pivottable?
peiyezhu sorry my bad. say there are rows with incomplete entry, e.g. start date there but not the end date, vice versa or both the columns are empty or even the complete row is empty (data yet to be entered).
blank means no value entered (null)
yes, that’s the ultimate goal but in order to get there I would need a query that would list all months where an activity occuring between the start and end date.
does that help?