Forum Discussion
Help needed - filter, power queries and pivot
Hi smsayedee
Not sure I fully understand how you want to represent your filter. See if Sheet2 (done with Power Query) allows doing what you expect, otherwise please clarify
There's probably something to do. However, what "MMMM yyyy" - or any other value i.e. null - should be returned in such a case?
Lorenzo thanks for helping me out. I've attached a mockup spreadsheet so that I probably be able to explain my problem better. In the spreadsheet, the Sheet1 contains the raw data with sheet 'Table1' is the output of query. Now you would notice that there may be some blank rows in Table1, especially some may have start date but not the end date, some may not have both and others may be completely blank rows. I want these incomplete rows not to be included in the output of the query.
Therefore, incorporating your previous solution to get the period for each activity I want to create a pivot slicer with list of months that allows me to filter the activities that are occurring that month.
Again, thank you so much for your help with this. 🙂
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?
