Forum Discussion

rohanghule12's avatar
rohanghule12
Frequent Visitor
3 years ago

How to write import query for measures.

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

3 Replies

  • Mahesh0016's avatar
    Mahesh0016
    Icon for Super User rankSuper User
    3 years ago

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

    • rohanghule12's avatar
      rohanghule12
      Frequent Visitor
      3 years ago
      • 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's avatar
        Mahesh0016
        Icon for Super User rankSuper User
        3 years ago

        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.