Forum Discussion
smsayedee
May 30, 2023Copper Contributor
Help needed - filter, power queries and pivot
Hi All, I've a table with below details: Column A: Activity Name Column B: Start Date Column C: End Date Now an activity can be completed in a day, so the start and end date are the same o...
- Jun 04, 2023
Linking posts is appreciated, marking solutions helps people who Search - Thanks
See attached file that does what you expect in term of Count by Activity Status
Lorenzo
Jun 01, 2023Silver Contributor
I want these incomplete rows not to be included in the output of the query OK, no problem
I want to create a pivot slicer with list of months that allows me to filter Do you run Excel on Windows?
smsayedee
Jun 01, 2023Copper Contributor
Lorenzo Thank you!
excel on windows. But the spreadsheet actually saved in sharepoint for collaboration. So other user can use it from other platform. Does it matter?
- LorenzoJun 01, 2023Silver Contributor
excel on windows. But the spreadsheet actually saved in sharepoint for collaboration. So other user can use it from other platform. Does it matter?
I was thinking of using the Data Model (Power Pivot). Will avoid then...