Forum Discussion

rima_ch's avatar
rima_ch
Frequent Visitor
4 years ago
Solved

undefined

Hello everyone,  I want to create a table that has only the year and month between 2 dates 2019-12-1 2024-12-31   my table needs to be like this  could someone please tell me what should I...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi rima_ch ,

     

    Check the new table formula.

     

     

    Table = distinct(SELECTCOLUMNS(CALENDAR(DATE(2019,12,1),DATE(2024,12,31)),"Year",YEAR([Date]),"Month",FORMAT([Date],"MMMM")))

     

    Best Regards,

    Jay

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi rima_ch ,

 

Check the new table formula.

 

 

Table = distinct(SELECTCOLUMNS(CALENDAR(DATE(2019,12,1),DATE(2024,12,31)),"Year",YEAR([Date]),"Month",FORMAT([Date],"MMMM")))

 

Best Regards,

Jay