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

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , you can not do it in column you can create table of dates

 

New Table =
var _month = month(Today())
var _year = if(_month <4, year(Today())-1, year(Today()))
var _st = date(_year,4,1)
return
calendar(_st, today())

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Amit,

    Thanks for your response.

     

    From my end a small correction in logic:

    If today's Date=19/05/2021

    then it have to populate dates starting from 01/04/2020 till 19/05/2020.

     

    Do we have any alternative approach to arrive it as column instead of table.