YTD Attrition Percentage

[Shashank_Y]

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 ?

[v-rongtiep-msft]

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 _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ExcelMonke]

Hello,

Can you share the structure of your data? This will impact the correct DAX to use.