Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Help with a calculation.

have a table in Power BI called AZB in which there are individual INV_NUM and order numbers with multiples Statuses. I want to count the # statuses in each order and I want to extract orders with mor...
Need Help
edhans's avatar
edhans
Community Champion
3 years ago

Can you show your data per the instructions below? An order header table typically has one line per order, so I don't know how any can have more than 1 status.

 

How to get good help fast. Help us help you.

How To Ask A Technical Question If you Really Want An Answer

How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

The first image is AZB. Each order can have multiple lines and invoices so I dedooped it on order + invoice number first because my client only wants the info on order numbers not the lines. Then I merged it with the Status from the Status Audit log in Power Query which is the second image. 

 

I made a SharePoint video but I am unable to share it here. edhans Is there a way I can email it to you?