Sep 28 2018 03:13 PM
Sep 28 2018 03:13 PM
Hi, I have a powerpivot workbook with 3 columns, one of the columns is 'Date'. I will be updating the workbook on a monthly basis, but I only ever want to see data from the current month. I was thinking of adding a NOW() function and then a formula stating that if the 'Date' falls within the same month of the NOW() column show the data, But I can't work out how to add it, any help would be really great.
Thanks
Sep 28 2018 06:23 PM
SolutionHi Michael, In Power Query you could filter the date column to show just "This Month" data
That way, if you only need to see Current Month data, that's all that gets loaded into the model
Oct 01 2018 08:06 AM
Thanks that's great didn't think of sorting it as a filter!
Oct 01 2018 09:17 PM
Sep 28 2018 06:23 PM
SolutionHi Michael, In Power Query you could filter the date column to show just "This Month" data
That way, if you only need to see Current Month data, that's all that gets loaded into the model