Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Solved! Go to Solution.
Hi @hozefamk
You could try something along these lines
Column = SWITCH( TRUE() , MID('Table'[ICODE],1,2) = "51" , 'Table'[Computers] , MID('Table'[ICODE],1,2) = "11" , 'Table'[Raw Materials] , BLANK() )
Hi @hozefamk
You could try something along these lines
Column = SWITCH( TRUE() , MID('Table'[ICODE],1,2) = "51" , 'Table'[Computers] , MID('Table'[ICODE],1,2) = "11" , 'Table'[Raw Materials] , BLANK() )
User | Count |
---|---|
124 | |
106 | |
99 | |
63 | |
59 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |