Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
You may create calculated tables within DAX.
https://powerbi.microsoft.com/en-us/guided-learning/powerbi-learning-2-6-create-calculated-tables/
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
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/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
116 | |
102 | |
78 | |
77 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |