Forum Discussion

marcio_fornari's avatar
marcio_fornari
Resolver I
5 years ago

Custom Column Today and Yesterday

Hello Everyone, i need help to add custom column into my calendar whit Power Query   I need a column write "Today" and "Yesterday".. but there are some conditions for this. It's very complex for...
Need Help
v-jingzhang's avatar
v-jingzhang
Community Support
5 years ago

Hi marcio_fornari 

 

Sorry I'm still very confused about the logic. Can you help answer the following questions first?

 

When you say "today is ...", does this "today" refer to the local date (system date) when you refresh the query?

 

In general, my understanding is that if "today" is a working day, its previous working day should always have "Yesterday" and its next working day should always have "Today". But in some of above examples Today has "Yesterday" (images 1, 3,5), and in image 4 it has "Today" while in image 2 it has null?

 

Additionally, all of your examples have an assumption that today is a working day. What if today is not a working day?

 

And in all examples, all holidays have only a single day. Will some holidays have several continuous days in the calendar? If so, what should be the result?

 

Can you help us understand the logic more clearly?

 

Regards,
Community Support Team _ Jing