How to write import query for measures.

[rohanghule12]

Please provide me import query for measures. I am able to fetch column and calculate column but facing issues while writing for measures. 

Please provide me syntax for measures

[Mahesh0016]

@rohanghule12  as per my experience, in Measure write aggregated function. We can not write a direct column in measure. Thank You!! 

[rohanghule12]

• Hello Mahesh, Actually I have report which is on live connection. Now I am changing to import mode where I am writing a DAX query to fetch data from SQL server. I am able to write and fetch calculate column but not able to write for measures getting syntay errors.

[Mahesh0016]

@rohanghule12 are you successfully loading your data in the power bi desktop with import data?
and if you succeed so please share your error Snap Shot for better understanding.