Forum Discussion
How to create custom YTD function
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
You must input the 3rd parameter in TOTALYTD function as the Year-End-Date. For example, if your fiscal year start 01/07/2019 (dd/mm/yyyy) the TOTALYTD will like this TOTALYTD( [Total Sales], 'Date'[Date], "06-30" ).
Hope this help.
Hi chawalit : Yes, the 3rd parameter works. However, my problem is in the data set and not the TOTALYTD function. The actual data set is little wiered. since my Financial year starts from Sep, the date is tagged from Sep 16 to Aug 17 as 2017. Hence, the need to create a custom YTD function.