Forum Discussion

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

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

Community 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

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

Nathaniel_C
Community Champion
4 years ago
Hi rima_ch ,
Here is a great blog from Matt Allington. https://powerbi.tips/2017/11/creating-a-dax-calendar/
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