Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 a...
Help appreciated
Help Requested
  • ValtteriN's avatar
    ValtteriN
    4 years ago

    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!

VahidDM's avatar
VahidDM
Icon for Super User rankSuper User
4 years ago

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/