Forum Discussion
Solved
Creating TTM chart with M language
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.
You may create calculated tables within DAX.
https://powerbi.microsoft.com/en-us/guided-learning/powerbi-learning-2-6-create-calculated-tables/
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.
You may create calculated tables within DAX.
https://powerbi.microsoft.com/en-us/guided-learning/powerbi-learning-2-6-create-calculated-tables/