Forum Discussion
DAX formula
Hi All,
I have imported the data in powerBI using API url. Because of that, I am not able to calculate using the column names.
I have attached the screenshot below:
Why do I get the URL and not the column names?
I would like to count the number of partnumber, but I cant select or type partnumber. I get an error.
What can I do so that I can get the count of partnumber?
Any help is appreciated!
Thank you!
Megha
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!
7 Replies
- VahidDM
Super User
Hi Anonymous
you can use the column names in your dax formula but your table name is too lng and there is no space for column names.
Change you table name to the short name then it will be fine.
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/ - AlexisOlson
Is 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!
