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
MODUser
Frequent Visitor

PeriodFilterTable PriorYear

Found a PeriodFilterTable to which I needed to add Prior Year. Added code is giving me the full prior year and the first day of the current year...I need only the prior year dates to output. Please advise. 

 

MODUser_1-1709915715103.png

 

 

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

Before the last comma insert  "-1"

View solution in original post

2 REPLIES 2
lbendlin
Super User
Super User

Before the last comma insert  "-1"

That's what I had tried, but didn't work...then I realized, after recieving your response that TodaysDate was not just a date, but a datetime zone so I used...

 

{"Prior Year",
Date.AddYears(Date.StartOfYear(TodaysDate),-1),
Date.StartOfYear(TodaysDate) - #duration(0,0,1,0),
8}

 

And that worked. 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.