Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

PowerBI q&a feature

Hi All,

 

I have few calculated measures in my data model and using the q&a feature I am trying to show the DAX query written to create the calculated measure. 

Can someone please tell me if this is possible using the q&a feature ?  

Need Help
  • v-henryk-mstf's avatar
    v-henryk-mstf
    5 years ago

    Hi Anonymous ,

     

    Use Q&A to explore your data using intuitive, natural language capabilities and receive answers in the form of charts and graphs. Q&A is different from a search engine -- Q&A only provides results about the data in Power BI datasets.

     


    You may be pursuing a function like quick measure.
    A quick measure runs a set of Data Analysis Expressions (DAX) commands behind the scenes, then presents the results for you to use in your report. You don't have to write the DAX, it's done for you based on input you provide in a dialog box.

    Just like below:

    For more details, you can read related document:

    Q&A for Power BI business users - Power BI | Microsoft Docs

    Use quick measures for common and powerful calculations - Power BI | Microsoft Docs


    Best Regards,
    Henry


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

4 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    5 years ago

    Anonymous Sorry, not entirely sure of what you are after. You can use the Performance Analyzer pane to expose the actual DAX query created when using a measure and such in a visual. I can't picture what you are trying to do.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Greg_Deckler Thank you for the response. Let me be provide some more details. I am just starting with PowerBI so might not be using correct terminologies.

       

      I have connected to my DB, fetched the data to PowerBI. I have also created few "New Measures" using the "Calculate" formula (as per the need).

      I am trying to use the q&a feature to display the formula on the screen. something like 

      "CALCULATE([new measure], DATEADD('table'[date], YEAR))" should be shown using the q&a feature.
      Is this possible using the q&a feature?
       
      Hope i am able to put across the question correctly.
      • Greg_Deckler's avatar
        Greg_Deckler
        Icon for Community Champion rankCommunity Champion
        5 years ago

        Anonymous No. Q&A feature is for generating visuals based upon natural language queries. Q&A will not return DAX formulas.

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi Anonymous ,

     

    Use Q&A to explore your data using intuitive, natural language capabilities and receive answers in the form of charts and graphs. Q&A is different from a search engine -- Q&A only provides results about the data in Power BI datasets.

     


    You may be pursuing a function like quick measure.
    A quick measure runs a set of Data Analysis Expressions (DAX) commands behind the scenes, then presents the results for you to use in your report. You don't have to write the DAX, it's done for you based on input you provide in a dialog box.

    Just like below:

    For more details, you can read related document:

    Q&A for Power BI business users - Power BI | Microsoft Docs

    Use quick measures for common and powerful calculations - Power BI | Microsoft Docs


    Best Regards,
    Henry


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.