Forum Discussion

TomMartens's avatar
TomMartens
Super User
8 years ago

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's avatar
njdeering
Frequent Visitor
8 years ago

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.