Creating TTM chart with M language

[njdeering]

How would I create a TMM chart using power query M language? I know you can do this with DAX, but then it doesn't allow me to see the values created. 

[TomMartens]

Hey,

wondering what your query is about.

Actually you can't create any chart using M. You use M to transform data from your source systems / files, creating tables with new rows / columns.

These tables are passed to the Power BI data model, from here you start your data visualization journey.

If you can provide more information about the structure of your source data, than it will be much more easy to recommend how to solve your issues and provide information how to create missing data and / or transform existing data.

Regards

Tom 

[njdeering]

Right, I understand that. I mean I'm trying to get the right values to put into a TTM type chart. I have 2 years of daily values. 

I know it's probably easier to do in DAX, but I can't really see or access the calculated values if I do that. I'm going to be applying more things to that data after it's created so I wanted to create an actual column in the table I have.

[v-chuncz-msft · Accepted solution]

@njdeering,

You may create calculated tables within DAX.

https://powerbi.microsoft.com/en-us/guided-learning/powerbi-learning-2-6-create-calculated-tables/