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
Hi sujitjena ,
Can you please share some sample data for test? It is hard to coding formula without any same data.
How to Get Your Question Answered Quickly
BTW, you can create a sorting table to achieve custom sorting, but it not works for time intelligence functions.
Custom Sorting in Power BI
Please use date function to manually filter on table records for rolling calculations.
Time Intelligence "The Hard Way" (TITHW)
Regards,
Xiaoxin Sheng
Hi Anonymous : Sure, Please find the sample PBIX file at below link.
https://www.dropbox.com/sh/kvofpp1iijhy6wa/AAB3JM4s-NHy9GTeQQfoQD3wa?dl=0
Thanks,