Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Columns Not Appearing in Measures With Direct Query Mode

Hi All,   I am facing a strange situation. I am using a direct query mode.   I need to convert the time zone from UAT to AST. The difference between UAT to AST is -3 hours.   My UAT time column...
Need Help
Tips and Tricks
amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , You can not see a column in measure, Use some aggregation like Min, Max, Sum or Sumx etc you wee see a column

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Amit,

     

    Thanks for your reply.

     

    When i have used SUMX function we are able to access the columns and i have written the following formula.

    But when i put this to table i am getting the following error.

    I have used the same formula with import mode and it is working fine.

    Please assist me here.