Forum Discussion

smsayedee's avatar
smsayedee
Copper Contributor
May 30, 2023
Solved

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...
excel
Formulas and Functions
Lorenzo's avatar
Lorenzo
Silver Contributor
Jun 01, 2023

smsayedee 

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...

smsayedee's avatar
smsayedee
Copper Contributor
Jun 01, 2023
I’ve been using data model, no issues so far!