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.

 

Ex: Toda's Date=19/05/2021 then it have to populate dates starting from 01/04/2021 till 19/05/2021.

 

Thanks in advance.

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

3 Replies

  • 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.

       

       

       

       

  • 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