Forum Discussion
count test frequency
Hello there. I need help for my problem here. Let say the table is below:
| Date tested | Equipment no. | Red cable | Yellow cable | Blue cable |
| 24/2/2019 | TRU1 | 0.1 | 0.1 | 0.1 |
| 25/2/2019 | TRU2 | 0.12 | 0.11 | 0.1 |
| 25/2/2019 | TRU3 | 0.1 | 0.11 | 0.12 |
| 2/3/2020 | TRU1 | 0.2 | 0.21 | 0.22 |
| 4/3/2020 | TRU3 | 0.21 | 0.2 | 0.21 |
| 5/6/2021 | TRU1 | 0.3 | 0.3 | 0.3 |
Then, I want to create table/column that will count the number of test for each equipment. The new table should be like this:
| Equipment | No. of test done |
| TRU1 | 3 |
| TRU2 | 1 |
| TRU3 | 2 |
I hope you guys can help me. Thank you in advance.
HI abgnfirdaus ,
Create a column with below code just in case if any of the column is blank
Column = COALESCE('Table'[Red cable ],'Table'[Yellow cable],'Table'[Blue cable])then use this new column as count on your visual
output:-
Thanks,
Samarth
3 Replies
HI abgnfirdaus ,
Create a column with below code just in case if any of the column is blank
Column = COALESCE('Table'[Red cable ],'Table'[Yellow cable],'Table'[Blue cable])then use this new column as count on your visual
output:-
Thanks,
Samarth
How to create a custom column to count how frequent the equipment have been tested.
Table 1:
Date Tested Equipment Red cable Yellow cable Blue cable 1/2/2018 TRU 1 0.1 0.12 0.1 2/2/2018 TRU 2 0.12 0.14 0.12 2/2/2018 TRU 3 0.12 0.11 0.1 3/4/2020 TRU 2 0.2 0.24 0.21 5/4/2020 TRU3 0.21 0.22 0.21 4/6/2021 TRU3 0.31 0.36 0.31
I want to create new column that will count the frequency of equipment have been tested. The table should show like this:Equipment Count of test TRU 1 1 TRU 2 2 TRU 3 3
Hope you guys can help me. thank you in adavance.Hi abgnfirdaus ,
You can refer to below thread:-
https://community.powerbi.com/t5/Desktop/count-test-frequency/m-p/2290371#M830064
Thanks,
Samarth
