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...
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.