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

Nathaniel_C's avatar
Nathaniel_C
Icon for Community Champion rankCommunity Champion
4 years ago

Hi rima_ch ,
Here are pics of steps in reverse order.  
Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel
Advanced Editor paste codeHome tab in PQ new source blank queryIn PowerBI Transform Data on home tabFinal table

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