Columns Not Appearing in Measures With Direct Query Mode

[Anonymous]

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

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.

Please assist here.

@Greg_Deckler @amitchauhan @gregdorval @amitchandak @JihwanKim @Jihwan_Kim @ChandeepChhabra @Mynda

[amitchandak]

@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]

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.

[Anonymous]

Hi Friends,

Please help me here.

@Greg_Deckler @amitchauhan @gregdorval @amitchandak @JihwanKim @Jihwan_Kim @ChandeepChhabra @Mynda