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 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
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
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
- 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 :)
