cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DAXLearning
Frequent Visitor

Acquiring data from a specific start date

Hi all,

 

I'm new to PowerBI at my company and I'm trying to setup a measure that pulls data from one table, that was created at the beginning of the year.  I have tried a few iterations of the date function with Calculate(Sum), but to no avail.   

 

Eventually I'd like to specify quarters, but for now since I'm so new, I'd like to have the measure specify that any data created after a specific date, would be drawn into the graph when selected.  

 

Thanks for any and all help!

 

LD

1 ACCEPTED SOLUTION

Accepted Solutions
DAXLearning
Frequent Visitor

Re: Acquiring data from a specific start date

I appreciate the suggestions,

 

I completely overlooked the TotalYTD option, so I spent a lot of time on a simple solution.

 

This should return all the data I need for now, but I'll keep the suggestions if I need to incorporate further information.

 

Thanks so much!

View solution in original post

3 REPLIES 3
AlexAlberga727 Resolver I
Resolver I

Re: Acquiring data from a specific start date

Static date, or dynamic?

 

There is a DAX expression to gather the difference between dates if needed.

 

DATEDIFF(date1,date2,interval)

 

Example of how to write the difference between 2 dates using variables and the DATEDIFF DAX.

Difference Between Days = 

VAR Day1 = MIN( fSales[InvoiceDate] )
VAR Day2 = MAX( fSales[InvoiceDate] )

RETURN
DATEDIFF( Day1, Day2 , DAY )

 

AlexAlberga727 Resolver I
Resolver I

Re: Acquiring data from a specific start date

Sales from XDATE to YDATE = 

VAR X = DATEADD( dDateTable[Date] , -90 , DAY )
VAR Y = TODAY()-1

RETURN

CALCULATE( [Total Revenue], DATESBETWEEN( dDateTable[Date], X , Y )
DAXLearning
Frequent Visitor

Re: Acquiring data from a specific start date

I appreciate the suggestions,

 

I completely overlooked the TotalYTD option, so I spent a lot of time on a simple solution.

 

This should return all the data I need for now, but I'll keep the suggestions if I need to incorporate further information.

 

Thanks so much!

View solution in original post

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.