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

rima_ch's avatar
rima_ch
Frequent Visitor
4 years ago

Thank you very much this is so helpful but could you please tell me how to create it Dax  and not power query