Forum Discussion
Trying to add a NOW() column to Powerpivot
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 think...
Hi 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
Thanks that's great didn't think of sorting it as a filter!
You're welcome, there's often a decision to be made re doing something in Power Query v Power Pivot. It's a bit of an art rather than a science. Lots of trial and error :)