The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello:
I am looking to average certain columns avoiding NA's. I have created a PBI file that has a table with mock data and the results I am hoping to achieve is pasted as an image on the first page. One issues is trying not to mix numeric values and texts. Any help on how to do this is very much appreciated! PBI attached.
https://drive.google.com/file/d/1GOLjgD8nmiLQ4ga8ynRQYaQx-5goNqm3/view?usp=drive_link
Hi @Whitewater100 ,
I can't download your pbix file, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
How to Get Your Question Answered Quickly
Best Regards
Community Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
26 | |
12 | |
8 | |
8 | |
5 |
User | Count |
---|---|
30 | |
15 | |
12 | |
12 | |
7 |