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!
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
Community ChampionHi,
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
Super User
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
