Forum Discussion
YTD quick measure not working
Hello,
I have created a YTD quick measure to calculate the total duration (hours) in the year.
Unfortunately, today on Jan-1, the data is not showing the duration as 0.
My understanding was YTD quick measure is for the current Calendar year. Any solutions, please.
Hi Anonymous,
Based on my research, the YTD quick measure is baed on TOTALYTD function and the return value is a scalar value that represents the expression evaluated for the current year-to-date dates.
What is your desired result? Could you please offer a sample data to have a test?
Regards,
Daniel He
5 Replies
v-danhe-msftMicrosoft Employee
Hi Anonymous,
Based on my research, the YTD quick measure is baed on TOTALYTD function and the return value is a scalar value that represents the expression evaluated for the current year-to-date dates.
What is your desired result? Could you please offer a sample data to have a test?
Regards,
Daniel He
Hi Daniel,
I was using YTD to calculate the total duration of hours that our organization invested in trainings for various resources from Jan-1 to Dec-31, 2018
The measure was not showing the duration as 0 on Jan-1, 2019. This was because there were no records of any training conducted in 2019. So while I added a record for 2019, the measure got reset and started showing from 2019.
Thanks.
- v-danhe-msft
Hi Anonymous,
If I understand correctly, that is how the quick measure work for your data and your understanding for this quick measure is also correct, could you please tell me if your problem could been solved?
Regards,
Daniel He