User Profile
sravani9920
Frequent Visitor
Joined 3 years ago
User Widgets
Contributions
Average on multiple columns Using DAX
Hello, I wants to find the average over multiple columns, Below is the Excel sample data and Col1 to Col11 are the columns to find average and "Average Column" values are average of the Col1:Col11 after rounding and next column is Before rounding. Note: I should replicate this average Function in the power BI using Dax Second and third row contains only numbers so while calculating average we don't find any issue in the power Bi as Excel Eg Col1+Col2------+Col11/11, But first and third row Contains both Numeric and non numeric it should take average for those Columns which are having numbers only 1st row 690/7=98.57 4th row 790/8=98.75 Can you please Help me how to achive this logic in power Bi when row has both numeric and non numeric values, Sum all the numbers(By ignoring text) and divide by only column count which has numbers instead of taking all the 11 columns to find average. I wants to show this Average in the Visualization like Table,Column Chart etc. Thanks in advance. Col1 Col2 Col3 Col4 Col5 Col6 Col7 Col8 Col9 Col10 Col11 Average 100 100 100 100 NA NA 90 NA 100 NA 100 99 98.57143 100 100 100 100 100 100 100 80 90 0 60 85 84.54545 100 100 100 100 100 100 100 0 90 0 70 78 78.18182 100 100 100 100 100 ? 90 NA 100 NP 100 99 98.75Solved1.1KViews0likes5Comments- 817Views0likes0Comments
Re: DAX needed
Helli MFelix, It worked well for me but need to extend the DAX calcultaed formula as sravani student in class 2 then the status should be Pass for class 2 as all the tests passed in class2 and same person is failed in class 1 so status for should be failed, Please help me out by extending the Dax calcultaed formula, Thank you 🙂843Views0likes2CommentsDAX needed
Hello Guys, I have provided the sample data for you, Here status column is the Result column for my requirement, student should be passed in all the tests then only status should be pass, If any student fail in one test also status will be fail, I need to present the data in PIE chart like number of test failed and passed. Please any one help me on this, Thank you in advance. number Name test Pass/fail status sravani test1 Pass fail sravani test2 Pass fail sravani test3 fail fail srinu test1 Pass pass srinu test2 Pass pass siri test1 Pass pass siri test2 Pass pass siri test3 Pass pass mokshu test1 fail fail mokshu test2 pass fail mokshu test3 pass fail mokshu test4 pass failSolved918Views0likes5CommentsUnpivoting Issue
Hello Everyone, My data as below, name age sub1 marks1 sub2 marks2 a 15 ENG 50 Hindi 48 b 18 MATH 45 Science 50 The below is the Output format , To get it I worked with unpivot and Grouping in power Query, But it's resulting incorrect result, could you please help me anyone to resolve this, Thank you in advance. name age sub marks a 15 ENG 50 a 15 Hindi 48 b 18 MATH 45 b 18 Science 50Solved1.5KViews0likes6Commentsat what Index the value occurred again?
Hi Guys, Please help me out, I am providing sample data for you, Here the output should be as Next Index column using PQE. Thanks in Advacne. number Index Next Index 100 1 2 100 2 3 100 3 20 1 2 20 2 150 1 2 150 2 3 150 3 4 150 4 5 150 5 10 1Solved692Views0likes3Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.