Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hey,
I can not wrap my head around on how to put the following Excel Formula in Power BI. The goal is to perform this calculation for each row in the Table (#rows =~200).
(COUNTBLANK(C2:GT2)/(COUNTA(C2:GT2)+COUNTBLANK(C2:GT2)-COUNTIF(C2:GT2;"N/A")))*100
Solved! Go to Solution.
Hi,
You may download the PBI file from here.
Hope this helps.
@Shippior
Can you share a sample of your data and how it organized? is it in columns or rows in Power BI ?
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
It is in columns in Power BI, I have tried to pivot the columns but to no avail. This is the data set and expected outcome I am working with: Dataset Link
Hi,
You may download the PBI file from here.
Hope this helps.
Thanks that worked. I had tried this solution before but apparently my data model was not set correctly to receive the expected outcome.
You are welcome.
please see the attachment below. hopt it's helpful.
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
98 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |