Forum Discussion
DAX formula
Hi,
Since your table name is so long the columns won't appear in the UI. The format that the columns appear in DAX is 'table'[column]. Now that your table name is so long you can't see the column names. I recommend renaming your table to something more descriptive. In addition to solving your issue it will make your data model more understandable.
I hope this helps and if it does consider accepting this as a solution!
Super UserIs that long string the name of one of your tables?
AlexisOlson Thank you for your reponse.
Yes it is.
But I cant seem to select any column for any kind of calculation.
Can I know why's that and what can be done?
Thank you!
Megha
- ValtteriN
Community Champion
Hi,
Since your table name is so long the columns won't appear in the UI. The format that the columns appear in DAX is 'table'[column]. Now that your table name is so long you can't see the column names. I recommend renaming your table to something more descriptive. In addition to solving your issue it will make your data model more understandable.
I hope this helps and if it does consider accepting this as a solution!- AlexisOlson
Anonymous It also appears that you have dates as columns. You probably want to unpivot those in the query editor.
I do want the dates as column names and hence did a pivot.
Thank you! AlexisOlson
Thank you! ValtteriN