Log In
Register
Home
New Member
October 1, 2020
Offline
Hello,
I have to prepare a bar chart in Power BI desktop showing the on time percentage total projects delivered in a period.
In excel I know how to do it but in Power BI desktop, I dont find the proper tools.
I am new in this field and any assistance would very helpful.
Thank you in advance,
Bogdan
See Answer
July 16, 2010
Offline
Hi Bogdan,
Welcome to our forum!
How are you calculating the 'on time delivery percentage'? Please provide an example formula that you'd use in Excel.
Mynda
New Member
October 1, 2020
Offline
Hi Mynda,
I have attached the test file updated with my formulas.
Tried to do the same in power BI desktop - query but not found the functions. If you can assist would be great.
Thank you.
Best regards,
Bogdan
November 8, 2013
Offline
Salut,
If you have tried to find in Power BI the same functions from excel, you should know that they are not the same, you have to build the calculations using M functions.
Try:
let
Source = Table1,
#"Filtered Rows" = Table.SelectRows(Source, each [#"Pre - calc"] <=0),
Result= Table.FromColumns({{Table.RowCount(Source)},{Table.RowCount(#"Filtered Rows")},{Table.RowCount(#"Filtered Rows")/Table.RowCount(Source)}}, {"Projects on Time","Total number of Projects","Delivery on Time"}),
#"Unpivoted Columns" = Table.UnpivotOtherColumns(Result, {}, "Attribute", "Value")
in
#"Unpivoted Columns"
Answers Post
1 Guest(s)
