User Profile
Nicks612
Helper I
Joined 2 years ago
User Widgets
Contributions
problem while plotting Scatter plot
Can anyone help me with plotting scatter graph for attached table? I have attached the pic of resulting graph using excel but unable to plot in power bi. Lower Data Upper 300 433.701 580 300 445.558 580 300 443.153 580 300 432.329 580 300 453.605 580 300 450.144 580 300 473.368 580 300 436.824 580 300 436.094 580 300 451.423 580 300 446.411 580 thanks in advance!Re: Need help for generating raw wise difference from column using DAX or power query
Hi @Nasif_Azam , Thank you so much for guidance and quick response. (Just for your information - I don't know much about M code so ignor silly mistakes I did when I followed these steps) What I have done first is - merge two tables as a new and then expand the remaining columns as shown in below M code. let Source = Table.NestedJoin(#"Raw Data", {"Index"}, #"Raw Data Prev", {"Index"}, "Raw Data Prev", JoinKind.LeftOuter), #"Expanded Raw Data Prev" = Table.ExpandTableColumn(Source, "Raw Data Prev", {"MAIN TR Power Reding ", "Bus Trunk -1 Meter reading", "Bus Trunk -6 Meter Reading", "Bus Trunk -2 Meter Reading", "Bus Trunk -4 Meter Reading", "Bus Trunk -3 Meter Reading", "6F2 Meter Reding", "Bus Trunk -5 Meter Reading", "Bus Trunk -9 Meter Reading", "Bus Trunk -10 Meter Reading", "Logistic Meter Reading", "Fan FDB Meter Reading", "Office + Canteen Meter Reading#(lf)", "ELDB Meter Reading", "Bus Trunk -7 Meter Reading", "8F4 Reading", "Main PDB Meter Reading", "U321 PDB Meter Reading (J3-601)", "PDB - 4 Meter Reading", "W601 Assembly Meter Reading"}, {"Raw Data Prev.MAIN TR Power Reding ", "Raw Data Prev.Bus Trunk -1 Meter reading", "Raw Data Prev.Bus Trunk -6 Meter Reading", "Raw Data Prev.Bus Trunk -2 Meter Reading", "Raw Data Prev.Bus Trunk -4 Meter Reading", "Raw Data Prev.Bus Trunk -3 Meter Reading", "Raw Data Prev.6F2 Meter Reding", "Raw Data Prev.Bus Trunk -5 Meter Reading", "Raw Data Prev.Bus Trunk -9 Meter Reading", "Raw Data Prev.Bus Trunk -10 Meter Reading", "Raw Data Prev.Logistic Meter Reading", "Raw Data Prev.Fan FDB Meter Reading", "Raw Data Prev.Office + Canteen Meter Reading#(lf)", "Raw Data Prev.ELDB Meter Reading", "Raw Data Prev.Bus Trunk -7 Meter Reading", "Raw Data Prev.8F4 Reading", "Raw Data Prev.Main PDB Meter Reading", "Raw Data Prev.U321 PDB Meter Reading (J3-601)", "Raw Data Prev.PDB - 4 Meter Reading", "Raw Data Prev.W601 Assembly Meter Reading"}) in #"Expanded Raw Data Prev" After that, I have replace the above code with your code as you suggested and end up with the following error - M code for this is - let columnsToCompare = {{"MAIN TR Power Reding ", "Bus Trunk -1 Meter reading", "Bus Trunk -6 Meter Reading", "Bus Trunk -2 Meter Reading", "Bus Trunk -4 Meter Reading", "Bus Trunk -3 Meter Reading", "6F2 Meter Reding", "Bus Trunk -5 Meter Reading", "Bus Trunk -9 Meter Reading", "Bus Trunk -10 Meter Reading", "Logistic Meter Reading", "Fan FDB Meter Reading", "Office + Canteen Meter Reading#(lf)", "ELDB Meter Reading", "Bus Trunk -7 Meter Reading", "8F4 Reading", "Main PDB Meter Reading", "U321 PDB Meter Reading (J3-601)", "PDB - 4 Meter Reading", "W601 Assembly Meter Reading"}, {"Raw Data Prev.MAIN TR Power Reding ", "Raw Data Prev.Bus Trunk -1 Meter reading", "Raw Data Prev.Bus Trunk -6 Meter Reading", "Raw Data Prev.Bus Trunk -2 Meter Reading", "Raw Data Prev.Bus Trunk -4 Meter Reading", "Raw Data Prev.Bus Trunk -3 Meter Reading", "Raw Data Prev.6F2 Meter Reding", "Raw Data Prev.Bus Trunk -5 Meter Reading", "Raw Data Prev.Bus Trunk -9 Meter Reading", "Raw Data Prev.Bus Trunk -10 Meter Reading", "Raw Data Prev.Logistic Meter Reading", "Raw Data Prev.Fan FDB Meter Reading", "Raw Data Prev.Office + Canteen Meter Reading#(lf)", "Raw Data Prev.ELDB Meter Reading", "Raw Data Prev.Bus Trunk -7 Meter Reading", "Raw Data Prev.8F4 Reading", "Raw Data Prev.Main PDB Meter Reading", "Raw Data Prev.U321 PDB Meter Reading (J3-601)", "Raw Data Prev.PDB - 4 Meter Reading", "Raw Data Prev.W601 Assembly Meter Reading"}}, AddDifferences = Table.TransformColumns( Merge1, List.Transform(columnsToCompare, each { "Diff " & _, each Record.Field(_, _) - Record.Field(_, "Prev." & _), type number }) ) in AddDifferences Can you please explain why I'm getting this error and suggest a solution? Thanks in Advance!Need help for generating raw wise difference from column using DAX or power query
Hello everyone, Can anyone help me with the below problem? I have attached table named "Raw Data" which contains the Date, Shift, Machine A & Machine B columns. Machine A & Machine B columns has reading of perticular machine stroks that machine has done in entire shift which is always in increasing manner. I want to calculate the difference between two reading of machine A as shown in the table named "Resultant Data". (similar, for the machine B also). then, want two plot a line chart indicating difference A & Difference B with respect to date & shift. Raw Data: Date Shift Machine A Machine B 5-25-2025 1st Shift 2644159 698871 5-26-2025 2nd Shift 2647818 699158 5-26-2025 3rd Shift 2651377 699249 5-27-2025 2nd Shift 2657855 699767 5-27-2025 3rd Shift 2661555 700028 5-28-2025 1st Shift 2663637 700123 5-27-2025 1st Shift 2663677 700325 5-28-2025 2nd Shift 2667838 700534 5-28-2025 3rd Shift 2671610 700781 5-29-2025 1st Shift 2673756 700877 Resultant Data: Date Shift Machine A Difference A Machine B Difference B 5-25-2025 1st Shift 2644159 3659 698871 287 5-26-2025 2nd Shift 2647818 3559 699158 91 5-26-2025 3rd Shift 2651377 6478 699249 518 5-27-2025 2nd Shift 2657855 3700 699767 261 5-27-2025 3rd Shift 2661555 2082 700028 95 5-28-2025 1st Shift 2663637 40 700123 202 5-27-2025 1st Shift 2663677 4161 700325 209 5-28-2025 2nd Shift 2667838 3772 700534 247 5-28-2025 3rd Shift 2671610 2146 700781 96 5-29-2025 1st Shift 2673756 4431 700877 -700877 Note A: In resultant column, I have calculated the Difference A & Difference B columns via formula. Please suggest measure & calculated column (both ways) to derived the difference. Note B: for date & shift hierarchy, should I have to go for manual hierarchy or we can add shift in default date hierarchy? Please guide me on this issue. Let me know if you need any further clarification or information. Thanks in Advance!Power BI - Ahmedabad - Hello everyone, Can anyone help me with the below problem? I have attached
Hello everyone, Can anyone help me with the below problem? I have attached table named "Raw Data" which contains the Date, Shift, Machine A & Machine B columns. Machine A & Machine B columns has reading of perticular machine stroks that machine has done in entire shift which is always in increasing manner. I want to calculate the difference between two reading of machine A as shown in the table named "Resultant Data". (similar, for the machine B also). then, want two plot a line chart indicating difference A & Difference B with respect to date & shift. Raw Data: Date Shift Machine A Machine B 5-25-2025 1st Shift 2644159 698871 5-26-2025 2nd Shift 2647818 699158 5-26-2025 3rd Shift 2651377 699249 5-27-2025 2nd Shift 2657855 699767 5-27-2025 3rd Shift 2661555 700028 5-28-2025 1st Shift 2663637 700123 5-27-2025 1st Shift 2663677 700325 5-28-2025 2nd Shift 2667838 700534 5-28-2025 3rd Shift 2671610 700781 5-29-2025 1st Shift 2673756 700877 Resultant Data: Date Shift Machine A Difference A Machine B Difference B 5-25-2025 1st Shift 2644159 3659 698871 287 5-26-2025 2nd Shift 2647818 3559 699158 91 5-26-2025 3rd Shift 2651377 6478 699249 518 5-27-2025 2nd Shift 2657855 3700 699767 261 5-27-2025 3rd Shift 2661555 2082 700028 95 5-28-2025 1st Shift 2663637 40 700123 202 5-27-2025 1st Shift 2663677 4161 700325 209 5-28-2025 2nd Shift 2667838 3772 700534 247 5-28-2025 3rd Shift 2671610 2146 700781 96 5-29-2025 1st Shift 2673756 4431 700877 -700877 Note A: In resultant column, I have calculated the Difference A & Difference B columns via formula. Please suggest measure & calculated column (both ways) to derived the difference. Note B: for date & shift hierarchy, should I have to go for manual hierarchy or we can add shift in default date hierarchy? Please guide me on this issue. Let me know if you need any further clarification or information. Thanks in Advance!
