Generating Dates

[Anonymous]

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.

[Anonymous · Accepted solution]

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]

@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]

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.