Forum Discussion

unnijoy's avatar
unnijoy
Icon for Post Prodigy rankPost Prodigy
6 years ago
Solved

YTD Attrition

I am trying to find the YTD Attrion. Below is the Sample data. I tried using Total YTD and DatesYTD function But these are not gving me the correct values. Please help.   Month Attrition Jan...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi unnijoy ,

     

    Do you want to calculate an accumulated result?

     

    If yes, Plesae try the below measure:

     

    measure = calculate(sum(value),filter(all(date),date <= max(date)))

     

    Aiolos Zhao

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

unnijoy , Are you using time intelligence with Date calendar

 

Like

YTD QTY = TOTALYTD(Sum('order'[Qty]),'Date'[Date])

YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD('Date'[Date],"12/31"))

 

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/

See if my webinar on Time Intelligence can help: https://community.powerbi.com/t5/Webinars-and-Video-Gallery/PowerBI-Time-Intelligence-Calendar-WTD-YTD-LYTD-Week-Over-Week/m-p/1051626#M184
Or my blog can help

https://community.powerbi.com/t5/Community-Blog/Decoding-Direct-Query-in-Power-BI-Part-1-Time-Intelligence-in/ba-p/922885

Appreciate your Kudos.