Forum Discussion
YTD Attrition Percentage
Hello All,
I have a table containing month on month attrition values, i was able to calculate month on month change in attrition, however i am stuck in getting YTD attrition change (difference in value from starting month of the year to current month ). Can someone please help me in this ?
2 Replies
ExcelMonkeImpactful Individual
Hello,
Can you share the structure of your data? This will impact the correct DAX to use.
Hi ExcelMonke ,
Thanks for your quick response.
Hi Shashank_Y ,
Please try to use Totalytd.
TOTALYTD function (DAX) - DAX | Microsoft Learn
YTD Sales = TOTALYTD(SUM(SalesAmount), Sales[Date])More details: How to Use TOTALYTD DAX function in Power BI for Trend Analysis - Zebra BI
How to Get Your Question Answered Quickly - Microsoft Fabric Community
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
