Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
NickProp28
Post Partisan
Post Partisan

DATEFROMPARTS take 2 year raw data

Dear Community,

 

How can I modify this query to take raw data for two years?

DECLARE @StartDate Datetime;
SET @StartDate = DATEFROMPARTS(DATEPART(YEAR,GETDATE()-2),1,1)
WHERE
JS_SystemCreateTimeUTC > @StartDate

Appreciate any help provided!  

1 ACCEPTED SOLUTION
VigneshSub
New Member

DECLARE @StartDate Datetime;
SET @StartDate = DATEFROMPARTS(DATEPART(YEAR,GETDATE())-2,1,1)
select @StartDate

VigneshSub_0-1672323398275.png

 

View solution in original post

1 REPLY 1
VigneshSub
New Member

DECLARE @StartDate Datetime;
SET @StartDate = DATEFROMPARTS(DATEPART(YEAR,GETDATE())-2,1,1)
select @StartDate

VigneshSub_0-1672323398275.png

 

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.