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]   B...
v-yanjiang-msft's avatar
v-yanjiang-msft
Icon for Community Support rankCommunity 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.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

The question is more around what is YTD doing to my measure?

my assumption was that YTD was including non school days,  weekends holidays etc and rounding the numbers over the extra days.

 

I have selected last year 

 

When I put the overall measure in a line chart by month it reports the same calculation as the YTD measure.