Forum Discussion

Qianru221's avatar
Qianru221
Icon for Helper II rankHelper II
8 years ago

Measures not shown in query mode

Hi all,   I have a query which contains records of product sales each day (there are multiple sales record for each day)   I then created another query which I summarise the sales for each day (s...
Need Help
Show and Tell
Tips and Tricks
v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi Qianru221,

 

You should use calculate column instead of measure because calculate column is contained in data model which can be seen in Query Editor after applied. However, a measure is in visual level which means it makes no effect on data model.

In Power BI desktop, both calculated columns and measures created on report level will not be applied to Query Editor. In your scenario, you need to use Power Query to create a custom column in Query Editor with the same logic.

 

Reference:

https://msdn.microsoft.com/en-us/library/mt211003.aspx

 

 

In addition, in Query Editor, if you add a custom column, you should use power query formula language, not DAX.

 

Best Regards,

Jimmy Tao

  • Qianru221's avatar
    Qianru221
    Icon for Helper II rankHelper II
    8 years ago

    Hi Jimmy,

    v-yuta-msft Thank you for you reply.

     

    I tried with adding custom column in the Query. However I have to use variables that come from other data queries and they can't be found when I was formulating the formula.....what should I do then?

     

    Best regards,

    Qianru.