Columns Not Appearing in Measures With Direct Query Mode

Question

Hi All,&nbsp;I am facing a strange situation. I am using a direct query mode.&nbsp;I need to convert the time zone from UAT to&nbsp;AST. The difference between UAT to AST is -3 hours.&nbsp;My UAT time column in the data is "CreatedDate".When I try to write the measure the IntelliSense list is not showing the column name.I am just wondering when we use the direct query mode PBI doesn't show column names?.&nbsp;Below is the screenshot for you reference.The formula i need is CreatedDate - TIME(3,0,0). This will give me the time in AST.&nbsp;Please assist here.Greg_Deckler&nbsp;@amitchauhan&nbsp;@gregdorval&nbsp;@amitchandak&nbsp;@JihwanKim&nbsp;@Jihwan_Kim&nbsp;@ChandeepChhabra&nbsp;@Mynda&nbsp;

amitchandak · Answer

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 · Answer

Hi Amit,&nbsp;Thanks for your reply.&nbsp;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.&nbsp;

anonymous · Answer

Hi Friends,&nbsp;Please help me here.&nbsp;@Greg_Deckler&nbsp;@amitchauhan&nbsp;@gregdorval&nbsp;@amitchandak&nbsp;@JihwanKim&nbsp;@Jihwan_Kim&nbsp;@ChandeepChhabra&nbsp;@Mynda

Forum Discussion

Columns Not Appearing in Measures With Direct Query Mode

3 Replies

Related content

Report not appearing in app

Measure two columns

Measure or Calculated Column

Column not appearing in query editor?

Blank columns when doing Measure Name Measure Value approach