cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
jayanthan Helper III
Helper III

Define Year End

Hi All

 

How do i define Year End in Power BI dax function, i was trying to use in previous year and sameperiodlastyear functions, it does not work, could you please send me sample pbix with those functions. In my country , year ends on 31st March 

 

 

Regards

Jayanthan

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

Re: Define Year End

@jayanthan,

 

You may try DATESYTD and TOTALYTD.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
themistoklis Memorable Member
Memorable Member

Re: Define Year End

@jayanthan

 

Maybe the function DATEADD and PARALLEPERIOD will be of use to you.

You can offset dates using the above function.

 

Check this link as well.

jayanthan Helper III
Helper III

Re: Define Year End

Hi themistoklis

 

Thank you , i could not define year end with those functions, could you please help

 

Regards

Jayanthan

 

 

Community Support
Community Support

Re: Define Year End

@jayanthan,

 

You may try DATESYTD and TOTALYTD.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors