Forum Discussion

sujitjena's avatar
sujitjena
Resolver I
6 years ago
Solved

How to create custom YTD function

Hi Everyone, I tried to create time intelligent function - TOTALYTD but it doesnt work for Fiscal year sorting based on my data set. So i want to create a custom YTD function that can add the values...
Need Help
sujitjena's avatar
sujitjena
Resolver I
6 years ago

amitchandak : You are right and i do understand the system configuration for time intelligence functions. So, as i see it now my only option is to change the data source to reflect the actual year ( Sep - Dec 2017 will change to Sep - Dec 2016 in the period column of fact table "GP Deployed").

 

Let me know if we can create custom function for YTD and LYYTD for any sort in Months of a year.

Thanks Again!

amitchandak's avatar
amitchandak
Super User
6 years ago

sujitjena,

 

Please note that all your LTD and LYTD calculations are working correctly. But when trying to display Calendar year and ordered by financial month, it gives the wrong message. Please check my pbix file shared

LYTD GP Total = TOTALYTD(sum('GP Deployed'[Total]),DATEADD(Dates[Date],-12,MONTH),"8/31")

 

 

https://www.dropbox.com/s/9g9uuqdcbvwexxz/PBIX%20View.pbix?dl=0

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

My Recent Blog -

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970


https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739

https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601