Year to date measure in PowerPivot

T

Tom83

New Member
Joined
Apr 23, 2021
Messages
20
Office Version
  1. 365
Platform
  1. Windows
Hi guys,

I have a dataset with a lot of financial records, both actuals up to today and budgets which can be in the future. I want to use a filter in a Pivot table which only shows data until a given date, for example March 31st for Q1 - 2021. This Q1 is entered in a cell as a parameter, next quarter I'm updating the cell to Q2, reload the data etc etc. How can I get Q1 in the datamodel to filter the dataset?

Thx!
 

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
Sort by date Sort by votes
Maybe by using a timeline slicers?
1621081215306.png
 
Upvote 0
You must log in or register to reply here.

Similar threads

Sandeep Warrier
  • Question Question
Year on Year, Quarter on Quarter change in Salary
Replies
0
Views
408
Sandeep Warrier
Sandeep Warrier
M
  • Question Question
DATEADD 'dates must be contiguous' error referencing measure in SWITCH formula
Replies
0
Views
2K
Maccer
M
M
  • Question Question
Measure needed to return last salesperson to have dealt with a customer
Replies
0
Views
487
mk4646
M
K
  • Question Question
Power Pivot: get value for Previous Non-Consecutive Date
Replies
4
Views
981
KeepTrying
K
F
  • Question Question
PowerPivot / DAX measure: Best 3 month period of sales
Replies
3
Views
766
fparadis1970
F

Forum statistics

Threads
1,223,714
Messages
6,174,055
Members
452,542
Latest member
Bricklin

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top