Forum Discussion

stevoboy's avatar
stevoboy
New Member
7 years ago
Solved

Query for Pie Chart

Dear all,   I am quite new to Power BI. Currently, I am facing beginners issue. The following I'd like to do in Power BI which I have done previously in Excel.   Data: Reported Event    Order   ...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    stevoboy  - 

    A couple notes:

    1. The script is for a DAX calculated column. You are in Power Query.

         a. It is also possible to perform this task in Power Query:

               -Make a copy of your query

               -In the new query, Group By Order to get Max of Status per order.

               -In the original query, Merge with the new query.

               -Expand the table to retrieve the Max Status.

    2. The script assumes your table is called Order Reported. You can substitute that text with the name of your table. 

    3. How to add a DAX calculated column: 

stevoboy's avatar
stevoboy
New Member
7 years ago

Thanks for your help. I put in your script, I get an error though. What am I doing wrong?

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

stevoboy  - 

A couple notes:

1. The script is for a DAX calculated column. You are in Power Query.

     a. It is also possible to perform this task in Power Query:

           -Make a copy of your query

           -In the new query, Group By Order to get Max of Status per order.

           -In the original query, Merge with the new query.

           -Expand the table to retrieve the Max Status.

2. The script assumes your table is called Order Reported. You can substitute that text with the name of your table. 

3. How to add a DAX calculated column: