Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

% not adding up when using YTD

Hi All,

 

I have two measures;

Att YTD2 = CALCULATE([Overall Att rate],DATESYTD('dimDates'[Date]),filter(dimDates,dimDates[DateId]))
Overall Att rate = [Present Att]/[Total Session Count]
 
But they both report different results, I added the filter on the ATT YTD2 as I could see it was including everyday in the calendar and not taking into account weekends and holidays, does it still calculate over 365 days regardless?
 
       overall              ATT YTD

Is there another way to calculate YTD or is there anything else to consider when using YTD?

 

Many Thanks

 

Andy

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , YTD should be like

     

    Att YTD2 = CALCULATE([Overall Att rate],DATESYTD('dimDates'[Date]))

     

    and dimDates should be marked as a date table

     

    Why Time Intelligence Fails - Power bi 5 Savior Steps for TI: https://youtu.be/OBf0rjpp5Hw

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      it still calculates the same value without the filter, i added the filter in the hope that was the issue as we only work on acedemic years and dont want to count non school days.

      DimDates is marked as a date table

       

      We 

      • v-yanjiang-msft's avatar
        v-yanjiang-msft
        Community Support
        4 years ago

        Hi Anonymous ,

        According to your description, you want dates not including weekends, here’s my solution.

        1.Create a new date table.

         

        2.Use the date table to calculate.

         

         

        Or you are still confused about it, please provide me with a sample and the output you expect.

        About DATESYTD function, you can refer to the following blog:

        https://docs.microsoft.com/en-us/dax/datesytd-function-dax

         

        Best Regards,
        Community Support Team _ kalyj

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