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
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.