Create a table using Calendar and a measure

[MickMQ]

I need to create a table using Calendar Month and an existing measure,  Tried SelectColumns and AddColumns but cannot get either to work.

[MickMQ]

Thanks - but I do not see this as a (general) solution to the question: How do I create a table?  It is adding column(s) to an existing table.  So, in a particular case, I would need to create/find a 1-column  table, add the column(s) that I need and then delete the original column.

[Idrissshatila]

Hello @MickMQ ,

It should work with add columns, check this article https://radacad.com/how-to-use-addcolumns-function-in-dax-and-power-bi

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin