Forum Discussion
Time table - financial YTD
Hello,
In my time table, I would like to create a column which indicates whether any given day is FINANCIAL YTD or not.
I already know how to create this column for calendar year:
if Date.DayOfYear([Date]) <= Date.DayOfYear(CurrentDate)
then "YTD"
else null
How should I adjust so that it would work for FINANCIAL year?
thanks a lot
6 Replies
- Fowmy
Super User
MiklosKonkoly
Not very clear about the requirement, can you provide a better explanation with sample data?Thanks for your quick reply. I emailed you a sample data with the time calendar.
Hi MiklosKonkoly ,
Could you tell me if your problem has been solved?
If it is, kindly Accept it as the solution. More people will benefit from it.
Or you are still confused about it, please provide me with more details about your problem.
Best Regards,
Stephen TaoHello,
My problem was not solved yet.
Fowmy requested more info, I sent them via email. I did not receive any feedback yet.
regards
Miklos
- Fowmy
MiklosKonkoly
I am not sure which email ID you emailed to. Anyhow, can you save your file in a cloud space like One Drive or Google Drive and share the link here in your reply so that anyone reading the question will have the chance to see the file?
