Conditional Column

[Anonymous]

Hi Community,

currently i have a problem with "add conditional column"....

I always want to have the value - of Today's date.

In the picture you can see that I set the date on 26.11 and stopped there.
Is there a possibility that the date automatically always selects the present one?

[AlB]

Hi @Anonymous 

You can use

= Date.From( DateTime.FixedLocalNow( ) )

directly. It will give you today's date

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[amitchandak · Accepted solution]

@Anonymous , You can create a column manually

example

new column = if([Column] < today(), 1, 0)

Refer: https://www.youtube.com/watch?v=wDS_Vi4r9I4