DAX last 30days/last years worth of data

Lamda

New Member
Joined
Mar 28, 2014
Messages
35
Hey all - i'm trying to figure out in DAX how to pull the last 30 days worth of data and also for 1 year. Been looking through docs and I can't seem to find the answer. Trying to put together a report and I have a running date column that spans a few years time. I am looking to pull some information and filter it on just the last 30 days and last year. What would be the DAX measure to do this? Any suggestions or helpful places to figure it out would be appreciated.

Thx!
 

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple
bump - and more info - I tried the function DatesinPeriod but I get errors with it saying its getting multiple values, etc.
 
Upvote 0
I usually do this by having a calculated column in my calendar/dates table that is "Is Recent 30 days", etc.
 
Upvote 0

Forum statistics

Threads
1,214,574
Messages
6,120,327
Members
448,956
Latest member
Adamsxl

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