SOLVED

Trying to add a NOW() column to Powerpivot

Deleted
Not applicable

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

3 Replies
best response
Solution

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

 

image.png

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 :)
1 best response

Accepted Solutions
best response
Solution

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

 

image.png

View solution in original post