Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Generating Dates

Hi All,   I have a Date field in my table. I have to create a new column based on date field.   Logic: If date=today's date then it have to populate dates starting from April till today's date. ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

     

    What's the expected result, Something like below?

    Column = IF('Table'[date]>TODAY()||'Table'[date]<DATE(2021,4,1),BLANK(),'Table'[date])

     

    Best Regards,

    Jay

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ,

 

What's the expected result, Something like below?

Column = IF('Table'[date]>TODAY()||'Table'[date]<DATE(2021,4,1),BLANK(),'Table'[date])

 

Best Regards,

Jay